Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please check the attached sample file. My goal is to hide resources that have allocation as 1 FTE but somehow Becky in example can't be hidden. Please help. Thanks!
Seems like the rounding issue
If(Round(Sum({<Version={'Planning Tool'}> } AssignedFTE), 0.0000000000001) = 1, 0, Sum({<Version={'Planning Tool'}> } AssignedFTE))
Hi Xia,
Please try below expression:
if(aggr( sum( {<Version={'Planning Tool'}> } AssignedFTE),Mth)=1,
0,
aggr(sum( {<Version={'Planning Tool'} > } AssignedFTE),Mth))
Regards,
Mayank
It's not working...
It now shows 2.8 under Becky's name...
Seems like the rounding issue
If(Round(Sum({<Version={'Planning Tool'}> } AssignedFTE), 0.0000000000001) = 1, 0, Sum({<Version={'Planning Tool'}> } AssignedFTE))
Works like a charm! Can you please let me know why we need to round by 0.0000000000001? The source data looks fine to me. Thanks again!
The numbers you are summing are 0.3 and 0.35... it seems that although it gets very close to 1, but never actually get 1. So, by rounding to a really small number, we are forcing it to be 1. I think Round(Exp, 0.0001) should work too... but I did this just in case