Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I'm facing problem in calculating %ges in pivot table. Please go through the below sample data and address me with the solution.
Data:
Note: Dedicated hours per day = 8
After converting pivot results should be as mentioned below..
But I'm getting different results as shown below. Results are calculated basing on the below mentioned formula but it should be based on the formula which mentioned above.
I tried to figure it out by set analysis but unable to get the correct results. Please help me to get the accurate results.
Can you try this
vAvailableDays = Sum(TOTAL <Analyst> Aggr(Count(Distinct Date), Date, Analyst))
What is the expression you are using today?
Hi Sunny,
Below is the expression which I used..
=100*$(vUtilizationHrs)/($(vAvailableDays)*8)
vUtilizationHrs = Sum([Utilized Hrs])
vAvailableDays = sum(Aggr(Count(distinct Date), Date,Analyst))
Can you try this
vAvailableDays = Sum(TOTAL <Analyst> Aggr(Count(Distinct Date), Date, Analyst))
Getting all zeros..
Would it be possible for you to share a sample?
Sorry... Its working fine
Thanks a lot..
Hi Sunny,
I missed something. Its working now.