Total Sum Expression

[khaycock]

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?             

[Anonymous]

Hi

Upload sample data am using personal edition. I can't open the application.

[Anil_Babu_Samineni]

Try to remove filter for Dealer Name and then look whether values are showing which is hide the 20 ??

[antoniotiman]

Hi,

You have 2 rows

Regards,

Antonio

[Frank_Hartmann · Accepted solution]

may be try:

sum( DISTINCT DEL_GBP_FREIGHT)

hope this helps

[khaycock]

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

[florentina_doga]

you have 2 rows for order no.100262879

see attach

[florentina_doga]

lastscandatetime and consignment have different value

[khaycock]

Even if remove those rows from the script it is still saying 40..

[florentina_doga]

maiby

ItemDetail:

LOAD  distinct ManifestDate,

//     Consignment,

//    AddressCode,

//     Service,

//     CustomerCode,

     Name,

     Address1,

     Address2,

     Address3,

     Address4,

     PostCode,

     Country

//     Package,

//     Reference,

//     From_Name,

//     Route,

//     Weight,

//     LastScan,

//     LastScanDatetime,

//     Reference2,

//     Reference3,

//     Reference4

FROM

(biff, embedded labels, table is Items$);