Skip to Content
0
Former Member
Jun 06, 2011 at 08:54 AM

Result Row of Formula is not using the displayed values

29 Views

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