Set analysis with date

[#1]

Hi.  I am trying to sum a field from a certain date onwards.  This works:

sum(if(KEY_Date>='2011/06/01',NumberRegistered))

The set analysis approach which actually what I want does not work:

sum({$<KEY_Date={">=2011/06/01"}>}NumberRegistered)

Can someone tell me where I am going wrong?  Thanks very much.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

The syntax should be

Sum({< KEY_Date = {">=$(=Date('2011/06/01'))"}>}NumberRegistered)

Provided your regional settings in your operating system are set to 'YYYY/MM/DD', otherwise you will need to modify them or make some formatting in the script.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Thanks Miguel - works perfectly!