Avg Bal Calc for a new fiscal year

[Former Member]

Hi

The avg bal calc needs to take into account that the start of a fiscal year ie period 1, should only take into account Current Period Movement Balance and not include Prior period balance. Thereafter period 2, must take into account current plus movement.

Any ideas. thanks

Mona

[Former Member]

I am trying create a query in Bex with these key figures.

When I run the query for avg bal it brings through period 12 and current balance of period 1. I need to create a calc key figure that gives me

avg bal = if period =1 then avg bal = monthly movement bal else if any other period then avg bal = avg bal + monthly movement.

In other words cumulative. Period 1 = period 1 , period 2= period 1 +period 2 etc

Thanks

Mona

[Former Member]

Hi,

It is end user decision . whther he can ask this AVG caculation to be done from Financial year starting OR last 12 periods (irrespective of Financial year) for a specific period.

With rgds,

Anil Kumar Sharma .P

[former_member188325]

Hi,

Your Requirement not clear.Can tell us indetail?