Total Sum Split Expression

[khaycock]

I need to get a sum of a split charges expression. The expression was previously created as I need only 1 charge of 19.64 per Dealer per day. But now I need to sum these individual 19.64 charges to get a total per dealer. 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 a qvw with the different expressions in it to see if anyone can help. The TOTAL expression messes it up slightly

[trdandamudi]

What is your expected output ? I don't see a field [Total Ransomes Freight Charge] in your data model ...?

[khaycock]

I need a sum of all 'Split UPS Freight Charges' for each 'Dealer'

[sunny_talwar · Accepted solution]

What is a numeric output you are expecting to see and which of the two charts? If this is for the Total Freight Charge, may be this

Sum(Aggr($(vNewIntFreightCharge), ORDER_NUMBER, DATE, Name))

to get 608.84?

[vishsaggi]

Is this what you are expecting?