Skip to Content
0
Former Member
Jul 22, 2009 at 06:41 AM

Calculation of total depending upon the quarter selected

8 Views

Dear All,

User want to see the quarterly total of all the amount.

Key figure struture in report is:-

Quarter

Actual amount

plan amount

variance

This will display the result for every quarter. Now user want to see the quarter total.

I can achieve this by making the property of CALQUARTER to suppress results never. This will give me output at the end of everyquarter. But i have variance field in my report whichi is giving a problem.

Say for 1st three posting period the variance is 100 respectively then the quarterly variace is coming as 300 total. I dont want this . I want to apply formula here.

formula=(( actual variacne - plan variance)/plan variacne)*100.

How can i achieve this in BEx?

Thanks & Rgds,

Anup