
Re: Wrong Table Total
Sunny Talwar Dec 15, 2017 7:07 AM (in response to zahid Rahim )May be use this
Sum(Aggr(
((SUM(FABS(INPUT_QUANTITY))SUM(OUTPUT_QUANTITY))/SUM(FABS(INPUT_QUANTITY)))*100,
YourDimension/s))
Also, look here

Re: Wrong Table Total
zahid Rahim Dec 15, 2017 7:22 AM (in response to Sunny Talwar )Dear Sunny,
Thank you very much. You were always my life savor. May i know the reason as why my expression was showing wrong total whereas your gave correct totals.
Regards,
Zahid Rahim

Re: Wrong Table Total
Sunny Talwar Dec 15, 2017 7:32 AM (in response to zahid Rahim )What I gave you is basically doing sum of individual rows, where as without Sum(Aggr()) it performs the same calculation for the total row... i.e.
It will first perform the numerator calculation and sum it up
((SUM(FABS(INPUT_QUANTITY))SUM(OUTPUT_QUANTITY))
and then the denominator calculation
SUM(FABS(INPUT_QUANTITY))
and then divide it....
Does that make sense?



Re: Wrong Table Total
Andrea Gigliotti Dec 15, 2017 7:12 AM (in response to zahid Rahim )try with below expression:
(
sum( FABS(INPUT_QUANTITY)  OUTPUT_QUANTITY )
/
SUM( FABS(INPUT_QUANTITY) )
)
* 100