Grand total with Absolute value

[bharani8]

Hi Team - I have issue in Populating "Shipment %" because Values which are populated in "Shipment Delta" are Absolute values. What output i need from the below screen shot is.. For Grandtotal (Bolded in last row), for "Shipment %" it should calculate 3870/1164425 which is 0.33%.. "Shipment Delta"(OARS Shipment Qty - ODW Shipment Qty) are Absolute values. 3870 is Sum of all the Rows (Not Expression Total). Now how do we get this to 0.33% ?

@sunny_talwar  Hope u have different approach to get this done.. Counting on u!

Expressions used for below 4 columns are:

OARS Ship Qty : Sum(GROSS_SHIP_QT)   Grand Total: Expression Total (Total Mode)

ODW Ship Qty : Sum([L4 Gross Shipment MS Quantity])   Grand Total: Expression Total (Total Mode)

Shipment Delta : fabs(Sum(GROSS_SHIP_QT) - Sum([L4 Gross Shipment MS Quantity]))   Grand Total: Sum of Rows(Total Mode)

Shipment % : fabs(Sum(GROSS_SHIP_QT) - Sum([L4 Gross Shipment MS Quantity]))/sum(GROSS_SHIP_QT)   Grand Total: Expression Total (Total Mode)

Regards

Bharani

[sunny_talwar · Accepted solution]

Not sure what the chart dimension/s are, but assuming they are A, B, & C.... try this

Sum(Aggr(
   fabs(Sum(GROSS_SHIP_QT) - Sum([L4 Gross Shipment MS Quantity]))
, A, B, C))
/
Sum(Aggr(
   Sum(GROSS_SHIP_QT)
, A, B, C))

[bharani8]

Worked Perfectly!!! U r a Star!! Tks for helping on this!! 🙂