Hi guys need help with total in the attached application there are 2 columns Frt Test and Pr Frt Test which we need to focus I am getting two different values in these columns one is 126 and other being 172. 126 I am getting by using sum of rows in the expression tab.What I want is to store this 126 in an expression so that I can use it further in calculations.
I am looking for Primary frt*Qty grouped by Sub Division,for med device it should give a sum of 126 not 172 as it is giving the total,anyhow.
Also please see the order type is SO.
I took it in excel and found out there is a lil difference between these two columns in the last of the rows.
Appreciate your help.
