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.
Solved! Go to Solution.
Try to remove filter for Dealer Name and then look whether values are showing which is hide the 20 ??
But when I want to do a total sum in another chart of all the £20 charges, I can't DISTINCT it because it will return only 20 when it should actually be 60?
If i take out the DISTINCT I get the problem again...
What could I do in this situation?
I'm also trying to get a sum of the Split UPS Charge but that seems impossible too
LOAD distinct ManifestDate,
(biff, embedded labels, table is Items$);