BALANCE

[BOMEXPORT_ADMIN]

Hello everyone ! 

Please help with me with that 

I'm working on a simple balance app, on particular thing about it is to calculate the balance for each operation, that means for each line ordered by date, i've tried a spreadsheet formula but this starts making calculations errors everytime i start editing between lines. i've also tried applying the bellow formula :

(
  ANY(
    SELECT(
      table[Balance],
      (
        [_ROWNUMBER]
        = MAX(
          SELECT(
            table[_ROWNUMBER],
            ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
          )
        )
      )
    )
  )
  + [Receipt]
  - [Payment]
)

but i'm still getting the same calculation errors between lines...

any help please ?

Thanks in advance

[1minManager]

So I think you've got 3 things to do here, sum each day, order the rows (in a view or template?) and then only show the balance on the last item of that day.  To help the first one [Balance] needs to be

SUM(Select(Table[Receipt],[Date]=[_ThisRow].[Date]))
-
SUM(Select(Table[Payment],[Date]=[_ThisRow].[Date]))

 Simon, 1minManager.com

[BOMEXPORT_ADMIN]

Hello thanks for your reply, i'm gonna try this one, however i'm afraid a such formula may have impact on the app sync, don't you think so ?

[BOMEXPORT_ADMIN]

It's not working... the result i've got is a simple difference between receipt and payment, it's not a balacne at all. I've used a virtual column to apply your formula in a virtual column and this is the error message i've got <Unable to fetch app definition. Ran out of resources evaluating>

It's very strange to not find out any solution for a such simple app 😞

[1minManager]

Explain in words what the formula needs to calculate

[BOMEXPORT_ADMIN]

Hello

The formula will calculate the balance for each new record (line).