Convert if condition to set analysis

[shwetagupta]

Hi,

I want to convert this if condition into set analysis. Is it possible?

If(Num(Month(MaxInvoiceDate))- Num(Month(MinInvoiceDate))>=1 ,Count(distinct Contact_ID))

Thanks!!

[kkkumar82]

Count(Distinct {<Contact_ID = {"=($(Num(Month(MaxInvoiceDate))- Num(Month(MinInvoiceDate))))>=1"}>}Contact_ID)

If you have a dimension, replace first Contact_ID with that