how to calculate % value

[former_member196948]

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

[tanveer1]

Hi,

Try this formula

= Sum([sales revenue])/ ([sales revenue] in report)

Thanks,

Tanveer.

[former_member196948]

any resolution gurus?

[saurabh_sonawane]

Hi

just create a new mesrure name sumtotal

formula for that is

=Sum(Sum([Administration] +[Directorate]+[Finance]+[Human Resources]+[Sales]+[Service])ForAll ([departmen]))

and then just divide that with

sum([Administration] )/[sumtotal]*100

[saurabh_sonawane]

departmen	Administration	Directorate	Finance	Human Resources	Sales	sum total
1	37,500	104,800	118,300	37,500	197,430	1,343,830
2		75,600	82,000	37,500	196,080	1,343,830
3		75,600	82,000	37,500	88,920	1,343,830
Sum:	37,500	256,000	282,300	112,500	482,430
	2.79	19.05	21.01	8.37	35.9