Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working with the TOTAL qualifier, trying to get proper percentage of totals.
I'm running into a problem where TOTAL does not return a SUM:
Service Inv Amt =
Sum( {$<[Invoice-Type]={'SER'}>} [invoice.Gross-amt]+ [invoice.Extra-Charge__1]+[invoice.Extra-Charge__2]+
[invoice.Extra-Charge__3]+[invoice.Extra-Charge__4]+[invoice.Extra-Charge__5]
+[invoice.Extra-Charge__6]+[invoice.Extra-Charge__7]+[invoice.Extra-Charge__8]
+[invoice.Extra-Charge__9]+[invoice.Extra-Charge__10])
If left alone, the total in that column would be 128,140,264.67. However, that does not accurately reflect the total of the column. Changing the "Totals function" to "Sum" fixes it. However, this does not fix the way the total qualifier works. The "Total" column is:
( sum(total {$<[Invoice-Type]={'SER'} >}
[invoice.Gross-amt]+ [invoice.Extra-Charge__1]+[invoice.Extra-Charge__2]+
[invoice.Extra-Charge__3]+[invoice.Extra-Charge__4]+[invoice.Extra-Charge__5]
+[invoice.Extra-Charge__6]+[invoice.Extra-Charge__7]+[invoice.Extra-Charge__8]
+[invoice.Extra-Charge__9]+[invoice.Extra-Charge__10]) )
How can I force the TOTAL column to show the actual SUM of my expression?
That fixed it! Changing to RangeSum and using 1499.99 gives me perfectly matching numbers every time. Thanks again!
Not a problem. I am glad we were able to help.
Best,
Sunny