Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table :
ID | Old Date | New Date | Difference |
---|---|---|---|
2 | 10/10/2018 | 10/10/2018 | 0 |
5 | 10/10/2018 | 15/10/2018 | -5 |
My "Difference field is defined thanks to the following expression :
=If(NetWorkDays([Old Date],[New Date])>0,
NetWorkDays([Old Date],[New Date])-1,
-NetWorkDays([New Date]],[Old Date)+1)
I would like to add a KPI showing the number of ID that have the "Difference" field different to 0.
I tried the following expression :
Count({< If(NetWorkDays([Old Total Date début],[New Total Date début])>0,
NetWorkDays([Old Total Date début],[New Total Date début])-1,
-NetWorkDays([New Total Date début],[Old Total Date début])+1)<>{0}>} MSN)
But it's not working, I'm not very familiar with Set modifiers.
Could I give a name to the expression in blue in order to use it again ? I created a custom measure but doesn't seem to work if I want to use the name of my measure.
Best regards,
Caroline
Hi Caroline
No, just load new data and the table will recalculate.
/teis
Please closed the issues if above solves the problem.
Try replacing following in your expression :
<> 0"}
With
= {"<>0"}
So it would look From:
+1) <> 0"}>} ID)
To
+1) ={"<>0"}>} ID)
NOTE: You would have reformat your expression to escape double quotes.
I had issue when used > sign with a number and only way to achieve that was to pass it with "equal to sign" and comparison condition(signs) as a part of the string.
Let us know if you still have issues with modified expression.
Thanks