Result Row of Formula is not using the displayed values
I got a query with following layout
Child Ship Parent Ship Rate Child Parent ST ST % Material A F6WH F6WH 55 22 250,00 F7D1 F7D1 55 33 166,67 F8LG F8LG 55 11 500,00 Result 55 66 250,00
The child ship key figure has a setting calculate result as average to display the total shipment of the child. Rate is defined as formula Child Ship %A Parent Ship.
In the result row as Rate I require 83% (55 divided by 66).
It seems that the Rate formular still uses the SUM of child ship 555555 (165 diveded by 66).
Anyone an idea how to get the "wanted result" of 83% ?
Thanks for all replies in advances (points will be assigned).
Anshu Lilhori replied
As far as i understand the issue is with the child ship keyfigure in that you have selected calcualte result as average which is only for display purpose that result cant be used for futher calculations.
If you want to calculate the average make use of exception aggregation.
Make a new formula and put you keyfigure for which you need to calculate avg. then hit Aggregation tab---Exception aggregation as average and refernce characterstic choose on which you are getting unique set of values.
Then continue with your other steps.
Hope it helps.
Edited by: AL1112 on Jun 8, 2011 2:35 PM