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