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
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
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 ?
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 ๐
Explain in words what the formula needs to calculate
Hello
The formula will calculate the balance for each new record (line).
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |