Skip to Content
0
Apr 22, 2015 at 04:50 PM

how to calculate % value

15 Views

Hi Gurus,

I have an query. i need to create 2 report from dept,showroom and sales revenue. i have created crosstab to achieve below requirement.

1st report is working fine. but i am getting below #multvalue error. i have created variable with for each and for all but i am not able to achieve the requirement

dept/showroom Administration Directorate Finance Human Resources Sales Service Sum: 1 37,500 104,800 118,300 37,500 197,430 70,200 565730 2 - 75,600 82,000 37,500 196,080 70,200 461380 3 - 75,600 82,000 37,500 88,920 32,700 316720 Sum: 37500 256000 282300 112500 482430 173100 1343830

dept/showroom Administration Directorate Finance Human Resources Sales Service Sum: 1 6.63% 18.52% 20.91% 6.63% 34.90% 12.41% 100.00% 2 16.39% 17.77% 8.13% 42.50% 15.22% 100.00% 3 23.87% 25.89% 11.84% 28.08% 10.32% 100.00% Sum: #MULTIVALUE #MULTIVALUE #MULTIVALUE #MULTIVALUE #MULTIVALUE #MULTIVALUE 100.00%

output should be

for example : 37500/1343830*100=2.79

Sum: 2.79% 19.05% 21.01% 8.37% 35.90% 12.88% 100.00%

i am using sap BI launchpad 4.1

Thanks in advance.

Regards,

Ranjeet