Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
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.
try this
Count ({<CampCreateDate= {"=CampCreateDate >= [Document Date]"}>} DISTINCT Contract_ID)
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
I know this was a few years ago now but I've just found a need and this sorts it for me. Thanks
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)