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
Set analysis only recognised '=' there fore you have to use ='<='
Look at this example from the help
Sum({<Year = {">=1978"}> } Sales)
Etay
Hi
for starters Try CampCreateDate = {
Which version are you working with ?? in addition to adding the = Set analysis had a problem comparing dates. We turn the date into a number and compare on that.
Etay
Hi,
Check with this
Count ({<CampCreateDate {"=Aggr(If(CampCreateDate >=[Document Date],CampCreateDate), CampCreateDate)"}>}DISTINCT Contract_ID)
Celambarasan
Set modifier error
We are running 10 SR 4
Hi,
typo mistake
Count ({<CampCreateDate ={"=Aggr(If(CampCreateDate >=[Document Date],CampCreateDate), CampCreateDate)"}>}DISTINCT Contract_ID)
Or check with this also
Count ({<CampCreateDate ={"=Aggr(If(CampCreateDate >=[Document Date],CampCreateDate), CampCreateDate,[Document Date])"}>}DISTINCT Contract_ID)
Celambarasan
Sorry but set analysis won't work for that. Reason is it's not processed as row per row basis, the set analysis result set is one and gets processed before the object does.
You need to do something like this or you can just add a flag in the script for those documents
Count (DISTINCT if(CampCreateDate >= [Document Date],Contract_ID))
Hi Thom!!
Are you still interested for solution?
I didn't recognize the post date!!!
However this expression works properly:
Supposing your pivot table has a structure like this:
Contract_ID - CampCreateDate - Document Date
the right expression is:
count ({< CampCreateDate= {'>=$(=date(max(aggr(max([Document Date]),Contract_ID&CampCreateDate&[Document Date])),'DD/MM/YYYY'))'} >} DISTINCT Contract_ID)
If you have problem I can send you my sample Qvw!
Let me know...
Bye!!
simply use below code
Count ({<CampCreateDate= {">=$(= [Document Date])"}>} DISTINCT Contract_ID)
hope this helps