User want to see the quarterly total of all the amount.
Key figure struture in report is:-
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,