Hi, can you help me please,
I have created a report that lists items that I need to calculate, each report may have a number of product listed on individual line and there are different type of products. I.e. AAF, WAT, BLA and so on tree are also different sizes to the products for instants.
These are made up in three field, size (9), Unit (LT), Type (AFF).
I need to list these on the report as laid out bellow
SizeUnit Type Total
9 LT WAT 2
6 KG DP 4
And so on.
Can you suggest the best way to create these calculations and where.
Thank you for your help.