Calculation of total depending upon the quarter selected

[Former Member]

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

[rathy_moorthy2]

Hi Anup,

I think unless u specify in properties as 'calcuate result as' as total it wouldnt come as 300.so when u have result as suppress never, It will do the calculation as per the formula defined for 'variance'.

i am assuming the field 'varaince' is a formula. or is it so?

Regards,

Rathy

[Former Member]

Hi Moorthy,

variance is a formula.

Quarter object used in hte key figure struture is a characteristics so i can't specify calculate result as total it only applies to key figures. For characteristics there is an option called Normailze to :- 'No normalization, Query result, Overall result, and Resul'. I dont know if we can use any of these???

Suppress results never will automatically take the summation only.

Thanks & Regards,

Anup

[rathy_moorthy2]

Oh, but in my query if i see for the 'formula' column,the total is showing as the value calculated from the values in the other fields in the 'total' row, and not the summation.I did not make any setting for it.

Regards,

Rathy

[rathy_moorthy2]

Hi,

It would be helpful if u would kindly post the solution here.

Thanks & Regards,

Rathy