Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having a weird problem with the sum of many freight charges where the total sum of DEL_GBP_FREIGHT should be 20.00 as there is only 1 lot of 20.00 in the set of data, but the expression is calculation 40 and I have no idea why!!
This might be something silly but I really can't figure it out. I think its having an effect on another expression too.
Any ideas?
Commenting on fields does not remove duplicates
Ahhhh that's amazing thank you!!
Do you think you could help me with getting a total of the split charges as well? I'm basically trying to SUM the total UPS charge which is £19.64 per day of deliveries. I have the split sum working in the pivot table fine but now i need to sum those 19.64s to create a variance against the other freight charge for the Total Freight Charge table.
I've attached another qvw with the expression in it...