Result Row of Formula is not using the displayed values

[Former Member]

Good Day,

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).

Axel

[anshu_lilhori · Accepted solution]

Hi,

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.

Regards,

AL

Edited by: AL1112 on Jun 8, 2011 2:35 PM

[cornelia_lezoch]

Hi,

probably you need to work with the setting "Formula Collision"

Go to the formula from which the result you want to see, Properties "Advance" and set it to "Use result of this formula".

regards

Cornelia