Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to calculate %Calculation like below ...
AFabulous BPerformance CExcellent DVeryGood
Sum of salary 212000 104000 57000 68000
% Calculation 100% 104000/212000*100=49.05% 57000/212000*100= 26.88% 68000/212000*100= 32.07%
Snapshot is also attached here for more clarity of understanding....
In 1st snapshot there is no expression added called %Calculation
In Second snapshot the %Calculation expression showing wrong percentage. i want %Calculation to be shown in Total Mode only... not with Dimension's ..is it possible ,if yes then suggest me how i can achive the same with above calculation.
my Qvw is also attached here for your reference.
Sarfaraz
Try this
=Sum(SALARY) /Sum(TOTAL {<Remarks={'AFaboulous'}>}SALARY)
If I have understand correctly you can try Sum(SALARY) /Sum(TOTAL SALARY)
use this,
expression: =Sum(SALARY) / Sum({<Remarks={'AFaboulous'}>} Total SALARY)
check out the attached qvw for solution
Hi
The expression should be =Sum(SALARY) / Sum({<Remarks={'AFaboulous'}>} Total SALARY)
And the number format should be set to fixed/percent.
HTH
Jonathan