Percent to Total in QS

[tmumaw]

How do you do a % to total in QS?  I know it was very easy in QV.  Thanks

Here's the calculation I'm using.

(Sum({<YTDFlag = {1}>} Amount) * -1 / Sum ({<[Reference Transact._AWTYP] = {'BKPF'}, YTDFlag = {1}>}Quantity_MSL)) /
Sum({<YTDFlag = {1}>} total <FISYR> Amount) * -1 / Sum ({<[Reference Transact._AWTYP] = {'BKPF'}, YTDFlag = {1}>} total <FISYR> Quantity_MSL)

[rubenmarin · Accepted solution]

Hi, the total clause works the same way it was on QV. Have you found any isssue using it?

Maybe you need some extra parenthesys:

(Sum({<YTDFlag = {1}>} Amount) * -1 / Sum ({<[Reference Transact._AWTYP] = {'BKPF'}, YTDFlag = {1}>}Quantity_MSL)) /
(Sum({<YTDFlag = {1}>} total <FISYR> Amount) * -1 / Sum ({<[Reference Transact._AWTYP] = {'BKPF'}, YTDFlag = {1}>} total <FISYR> Quantity_MSL))

[Vikash]

Hi,

You can do it by selecting the number formatting options as Number and selecting the Formatting as 12.34% from the drop-down lists. See below-

VK