Expression with calculated field

[Anonymous]

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

[teiswamsler]

Hi Caroline

No, just load new data and the table will recalculate.

/teis

Please closed the issues if above solves the problem.

[shaileshs]

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