Using Greater Than in Set Analysis

[tmumaw]

I am trying to use the following : Count ({<CampCreateDate {">= [Document Date]"}>} DISTINCT Contract_ID), but keep getting an error.  I want to count any contract where campaign create date is greater than or equal to document date.

Thanks
Thom

[alec1982]

Hi guys,

the following made it for me using Min and Max

num(sum( {$<RDATEValue={">=$(=(AddMonths(min([RDATEValue]),-12))) <=$(=(AddMonths(max([RDATEValue]),-12)))"}>} REV))

but what if the user makes few selections on the RDATEValue field and they are not in order?

meaning what if the user select 09/01/2014 and 06/01/2014 and 01/01/2014 We need to get the REV for the same periods from the previous year..

Let me know your thoughts..

[rajendra1918]

Hi All,

From the duration i'm trying to find greater than 95 days, 45 days and 30 days count on unique column Can you please help me how can i achieve it.

[Kushal_Chawda]

try this

Count ({<CampCreateDate= {"=CampCreateDate >= [Document Date]"}>} DISTINCT Contract_ID)

[rajendra1918]

Hi Kushal- Thanks for your quick response.

Count ({<CampCreateDate= {"=CampCreateDate >= [Document Date]"}>} DISTINCT Contract_ID)

i have a confusion with below columns only. can u please specify on this. which i have to use.

CampCreateDate

[Document Date]

contract ID i know as i have contract number.

Requirement --> count of >90 days,>45 days & >35 days .

Regards,

Rajendra

[campbellr]

I know this was a few years ago now but I've just found a need and this sorts it for me. Thanks

[akshaye_c_navale]

Try This,

Calculate difference between dates for getting no of days says NoOfDays

say vDaysCondition1=90

     ,vDaysCondition2=45

     ,vDaysCondition3=35

for count greater than 90 -->> Count({<[NoOfDays] = {'>=$(vDaysCondition1)'>}DISTINCT Contract_ID)

for count greater than 45 -->> Count({<[NoOfDays] = {'>=$(vDaysCondition2)<$(vDaysCondition1)'>}DISTINCT Contract_ID)

for count greater than 35 -->> Count({<[NoOfDays] = {'>=$(vDaysCondition3)<$(vDaysCondition2)'>}DISTINCT Contract_ID)