Hi Guys
I looking for a virtual column called [Balance].
Hopefully the below picture and remarks explains my situation. I would appreciate the support.
I think the expression should be something looking for the following arguments
IF([Category] = "Opening Balance}, True = This Row [Balance Value], False = This Row [Amount] + [Balance] of the previous dated row of the same account name as this row.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |