Using Variable in Set Analysis

[mphekin12]

Hello,

I am trying to get a count of cases based a two variables that the end users set.  I have tried several variations of the following formula:

count({$<($(vEndField)-$(vStartField))={'>0'}>}distinct CASE_NUMBER)

I cant seem to get this work.  Any ideas?

Thank you!

[Anonymous]

HI,

Try this:

count({$<($(=($(vEndField)-$(vStartField))))={'>0'}>}distinct CASE_NUMBER)

[sunny_talwar · Accepted solution]

May be try this:

Count(DISTINCT {<CASE_NUMBER = {"=$(vEndField) - $(vStartField) > 0"}>} CASE_NUMBER)

[kaushiknsolanki]

Hi,

Can you explain using some example.

Regards,

Kaushik Solanki

[mphekin12]

Sorry sbobbyraj but your solution didn't work.  Thanks for the help!

[mphekin12]

Thanks Sunny, your solution seems to be working for me!