Calculate Account Balance (i.e This row vs previous dated row with conditions)

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.

0 1 186
1 REPLY 1
Top Labels in this Space