Calculated key figure

[former_member820887]

Dear experts,

i need to calculate average price for  product , how do I calculate in query designer .... Please tell what exact configuration/settings I have to do in query designer..??

thanks in advance experts.

[Former Member]

Hi Goel,

You can achieve your scenario by using :

Go to Query Designer -> Drag the "Price" Key figure in Columns and the Characteristics in Rows(Which you want to include in your report)-> Right Click and Say "Create Formula" , under which select 'Price' Key figure -> Now go to 'Aggregation' tab and Select Exception Aggregation as "Average".- > Now in Refernce Characteristics 'Select Product' and save the Formula.

Now Open your query in any tool like Analyzer to verify your result.

Now here in the output you can see, we have 10 products and the total is 650,000 and the Average on the basis of Product should be 650,000/10.

So the output will be 65,000.

Please revert back for any queries.

Thanks,

Rahul

[Former Member]

Hi,

you can achieve by going to key figure  properties --> Calculations -->Calculate result as -->choose Average from drop down.

[KodandaPani_KV]

Hi,

create the new formaula -> put the which key figure you want > hit the aggregation tab -> select exception aggregation -> use the average -> save it -> execute it bex analyzer

rows panel put the product and remaing objects in free char panel

for product you will get the average value

Thanks,

Phani.