SETANALYSIS

[chapil]

Hello everyone 

I have a question : I want to put 2 conditions in my set analysis and one is compose with a function and it doesn't work 

Can someone help me with the write syntax, thanks 

So that's my problem : I want to count all the IDs wich has a date_1 null and IDs with  date_2>30 days from today 

So I wrote this expression which is false :

count ({$< [DATE 1] -={""}, [DATE 2] ={"<= today()-30"}>} [ID])

Thanks for the answer ! 

[joaopaulo_delco · Accepted solution]

Hi @chapil !

             Try this:

count({$<[DATE 1]-={"-"}, [DATE 2]={"<= today()-30"}>} [ID])

Please if it solve the problem mark the post as solution.

[stevejoyce · Accepted solution]

I believe it's your date expression.  You can try this:

count ({$< [DATE 1] -={""}, [DATE 2] ={"<=$(=date(today()-30))"}>} [ID])

[chapil]

Thanks, that's working !

[chapil]

Thanks a lot, both solutions are working 😉 

[joaopaulo_delco]

Hi @chapil , so, please mark some post as solution.