Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to calculate the percentage ,i am not able to sum the values of the Grand total because it is the expression in the chart option.The expression for grand total is: count({<CategoryDefect={'Application','User Training','Environment','App Config','Scope Change','Duplicate'}>}CategoryDefect).The Grand Total value is not static value it will change according to the selection of product line.
I have uploaded the excel sheet of the table that i want to be displayed .
Thanks.
Hey,
To get the percentage as another column,do use (Grant Total/Sum(TOTAL Grant Total))*100
but, to get at the bottom of the chart, I think u need to make use of text boxes.
HTH,
Ravi N.
i tried to take (Grant Total/Sum(TOTAL Grant Total))*100 it is showing Blank.No values are coming.
It should work. It worked for me. Nonetheless,use relative option. Just use sum(Grand) as exp and click on relative in the expression tab.
Please use this expression:
(sum(Grant Total)/Sum(TOTAL Grant Total)))*100
Hi May be like this
(sum(Grant Total)/Sum(TOTAL Grant Total)))*100
Or use Relative on expression.
Regards
ASHFAQ
Hi Nishika,
I tried your problem and i found the following solution that i tried in text box. it is as follows
=Num(Sum(TOTAL Application)
/
(Sum(TOTAL Application)+ Sum(TOTAL User Training)+ Sum(TOTAL Environment)+Sum(TOTAL APP Config)+Sum(TOTAL Scope change)+Sum(TOTAL Duplicate)),'#.#%')
you will get the 46.94% for ''2521/5370"
check it out.
Hi nishika,
please find attached QVW with solution
regards
harshal sonone
Hi
In chart properties for Number Tab against the expression set the number format to 2 decimal and check show in Percent option
Thanks
Satish
Hi Harshal,
I am not able to do it it is showing error in the statement ,I have attached the qvw file please check .