Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
What is your expected output ? I don't see a field [Total Ransomes Freight Charge] in your data model ...?
I need a sum of all 'Split UPS Freight Charges' for each 'Dealer'
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?
Is this what you are expecting?