Hi All
Hope you can help -
I have a report that contains fields as below
Order No
Customer No
Order Volume
Each order has a volume, and each Customer can have numerous orders,
At Grp Footer I have introduced two formula fields - one that sums the Order Volume by Customer then converts the volume to a pallet quantity based on a conversion factor.
Secondly I have used the truncate condition to round up the returned volume from the previous calculation - basically for example 1.2 pallets is rounded to 2 pallets etc.
This works fine in the group footer and returns the correct values however.........
Customer Order Volume Pallets Rounded Pallets
AAAA 4.2 3.2 4
BBBB 0.4 0.5 1
CCCC 2.1 1.7 2
I need one final value in the Report footer which is the sum of the rounded up qty - this I cannot get -
The value I need is "7" which is the sum of the Calculation which rounds up the converted volume.
I cannot use the calculation at Report Footer level as this will consolidate the volume for all the order and thus return the incorrect number of pallets.
The correct answer is the sum of the Formula Field {RoundedPallets]
Would be grateful if anyone can help
Thanks