Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I need to convert my expressions based on if-condition:
=Count(DISTINCT if(Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])and IsNull(Oppo_Closed) , OpportunityCD))
=Count(DISTINCT if(Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])
and IsNull(Oppo_Closed) , OpportunityCD))
To a set analysis !!!
thanks
Hi Hilal,
Try the below expression:
=count({<Oppo_CreatedDate = {">= $(=MonthStart(Datedopportunite)) <= $(=MonthEnd(Datedopportunite))"}, Oppo_Closed = {''}>} OpportunityCD)
Hi
Try like this
=count({<Oppo_CreatedDate = {">= $(=MonthStart(Datedopportunite)) <= $(=MonthEnd(Datedopportunite))"}, Oppo_Closed -= {'*'}>} Distinct OpportunityCD)
Try this:
=Count(DISTINCT {$<Oppo_CreatedDate={'=Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])'}, Oppo_Closed={'=IsNull(Oppo_Closed)'}>} OpportunityCD)
thanks for solutions but no one of these set analysis work, they return 0
Can you post a qvw so we can take a look at the dataset?