Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
It works, many thanks!
Glad to help. Thank you for the fast feedback.