Skip to Content
0
Aug 24, 2020 at 12:30 PM

bex query beginning balance calculation

25 Views

Hi,

I have 3 fields in my query columns

1)beginning balance(RKF restricted by year)

2)expense

3)ending balance formula(1+2)

Now i want to calculate beginning balance at runtime=>beginning balance of current year=ending balance of previous year

but ending balance is a formula(addition of field 1+2)