Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I have The total value within the lines are correct, but the total sum is wrong.
anyone know what change I need in the expression to have the right Total Sum?
My current expression is: Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8)))
May be this
Sum(Aggr(Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8))), Resource, [Project Name], [Business Area], Month))
Or this
If(Dimensionality() = 0, Sum(Aggr(Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8))), Resource, Month)), Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8))))
Last one:
There is a conditional before and then the subtraction:
if(Sum([Hours Resource])/
Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8)))
<=.99,
Sum(Aggr(Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8)))
-Sum([Hours Resource]),Resource,Month, [Resources Location])))
What can I do to show the totals?
May be this
Sum(Aggr(if(Sum([Hours Resource])/
Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8)))
<=.99,
Sum(Aggr(Sum(DISTINCT(if(Month=Month_Working_Days,Working_Days_Qt*8)))
-Sum([Hours Resource]),Resource,Month, [Resources Location]))),Resource,Month, [Resources Location]))
Totally worked! thanks a lot!