
Problem on expression using <total> for calculating percent of time
Stefan Wühl Feb 6, 2012 3:12 PM (in response to jkizanis)You can try disregarding the selection in the denominator:
sum(HoursWorked) / sum({<EmpName=>} total <Activities> HoursWorked)
And enable the option 'supress zero values' in presentation tab, if needed.
Hope this helps,
Stefan

Problem on expression using <total> for calculating percent of time
jkizanis Feb 7, 2012 4:56 PM (in response to Stefan Wühl )It worked. Thank you very much!


Re: Problem on expression using <total> for calculating percent of time
Rainer Filoda Feb 7, 2012 3:08 AM (in response to jkizanis)Hi,
maybe this modification of your expression is what you are looking for:
Sum(HoursWorked)/sum( {1} total<Activities>HoursWorked)
Good luck!
Rainer

Problem on expression using <total> for calculating percent of time
jkizanis Feb 7, 2012 4:57 PM (in response to Rainer Filoda )Thank you Rainer.

Problem on expression using <total> for calculating percent of time
Lav Jain Mar 16, 2012 6:47 AM (in response to Rainer Filoda )Hi,
i think you can solve my problem
i've dimemsions dim1,dim2,dim 3..in hierarchial format as in pivot table.
i've a value column in the table, as one expr....i'm showing sum(value) and i also have dimension due date....& if the due date <today() date then in the expr column Overdue Amt i simply show sum(value) else i'll show it the Not due column...this is fine....
now i've to find %Overdue & %Not due.....wich is Overdue Amt/sum(value) & Not Due Amt/sum(value) respectively...
i'm getting the % fine..for each row...but at the total level i dnt want to see sum of all % for Overdue & %Not Due
Bt only the sum of Overdue Amt/sum of Remainin Amt & same for %Not due as well
Plz help
stuck for 1 day cmplete
Regards
