Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
maybe because its a friday but I am stuck trying to figure this out!
I have managed to build differing measures which are correct but when I try to calculate the percentage based on the measures its not providing the correct output! I have performed the logic in excel but cant get it right in the expressions i am building, i know its probably something simple but I cant figure it out. see below:
i am expecting the following values though (excel screenshot below).
My expressions are:
Utilised Days - =Sum( {$<Usage = {"Utilised"}>} Days )
Total Days Minus Holidays - =Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days )
% Utilised = =Sum( {$<Usage = {"Utilised"}>} Days )/Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days )/100
Any help much appreciated.
thanks Martin
Try this
=Sum( {$<Usage = {"Utilised"}>} Days )/ (Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days ))/100
Try this
=Sum( {$<Usage = {"Utilised"}>} Days )/ (Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days ))/100
Thanks Sunny! I knew it was something simple!