Identifier in Set Analysis

[nigel987]

Hi, I am using following set analysis to count contracts:

='Contracts: ' & (Count({1<

  Status={'Active'},

  ContractEndDate={"=ContractEndDate>=Date(MonthsStart(1,Today(),1)) and  ContractEndDate<=Date(MonthsEnd(1,Today(),1))"}

  >}Distinct OrganisationID))

I want to ignore user-selections, therefore I used the identifier 1, but I think this does not work for the part:

ContractEndDate={"=ContractEndDate>=Date(MonthsStart(1,Today(),1)) and  ContractEndDate<=Date(MonthsEnd(1,Today(),1))"}

I tried to insert the identifier 1 into this part as well, but I couldn't get the syntax right.

Does anyone know how to write it correctly?

Thanks,

Nigel

[swuehl · Accepted solution]

Try

ContractEndDate={"=Only({1}ContractEndDate)>=Date(MonthsStart(1,Today(),1)) and  Only({1}ContractEndDate)<=Date(MonthsEnd(1,Today(),1))"}

edit:

or:

ContractEndDate={">=$(=Date(MonthsStart(1,Today(),1)))<=$(=Date(MonthsEnd(1,Today(),1)))"}

[nigel987]

Great! That's it. Thanks for the reply swuehl!