Cash Flow Imbalance

[YRSTRULY]

Please assist. I am trying to calculate the Cash Flow Imbalance from an Excel file(https://docs.google.com/spreadsheets...gid=2078998761), which uses formulas to get to the Totals of calculations. Cash Flow imbalance is made up of =K15-K91+K89 and so on.

I am getting a very high Cash Flow imbalance which should not be. I just want to make sure that i a adding and subtracting correctly, another eye on the sheet, please. The data in the sheet as it is can be considered dummy data for now. The formula patterns must be correct.

[Greg M]

Hi there,

Please post a copy of your workbook - the version of the workbook accessed via the link you posted is protected against downloading and copying.

Regards,

Greg M

[YRSTRULY]

You dont need to download or edit to see the formula. Just click on column k.

[AliGW]

We need to be able to edit to test solutions. Please do as Greg requested. Thanks.

[YRSTRULY]

It's editable now. Thank you.

[Greg M]

Hi again,

Sorry, but this is the type of spreadsheet that makes developers (and company auditors!) look for early retirement

In the column (K) in question, TWENTY cells display results calculated from sums/differences of cells in column K itself, and a further FIFTY-THREE cells display results calculated from sums/differences of cells in other columns.

To compound the agony, several cells contain values derived from the contents of the hidden columns L:X.

Your formulas also contain multiple instances of "magic numbers" (e.g. +2119461 - 334776):

Please Login or Register  to view this content.

Sorry if I appear critical or unwilling to help, but trying to understand the worksheet logic is (for me anyway!) not a straightforward task.

Regards,

Greg M

[YRSTRULY]

I know. Its a Hot Mess. I have to convert the formulas to Dax in PowerBI. The amount in question is supposedly to be 0.