Set analysis with formula and condition

[Fitus9092]

Hello i'm trying to use this formula in set analysis but it not work.

Count( {< esclusione = {'0'} , esclusione2 = {'1'}, Diff ={"=<90"}>} progressivoSDO_IMA_STEMI_PTCA)

Diff is a variable system with this formula :

num#(interval((dataInterventoPrincipale&' '&oraInterventoPrincipale - [dataora triage]),'mm'))

I tried this second formula in set analysis but doesen't work
Count( {< esclusione = {'0'} , esclusione2 = {'1'}, {="num#(interval((dataInterventoPrincipale&' '&oraInterventoPrincipale - [dataora triage]),'mm'))"} = {"<=90"} >} progressivoSDO_IMA_STEMI_PTCA).

Thanks

[Vegar · Accepted solution]

Set modifier should be defined for fields will not work on expressions.  I usually think of the modifiers as invisible selections made to the datamodel before calculating the expression.

Are you able to pre generate the num as a field in the script?

num#(interval((dataInterventoPrincipale&' '&oraInterventoPrincipale - [dataora triage]),'mm')) as [Diff]

If you are then the set can look like this in your application.

Count( {< esclusione = {'0'} , esclusione2 = {'1'}, Diff ={"=<90"}>} progressivoSDO_IMA_STEMI_PTCA)

[Fitus9092]

It works, many thanks!

[Vegar]

Glad to help. Thank you for the fast feedback.