Issue in calculating last 3 months

[fashid]

Hi,

I have an issue with the following set analysis creatd by me or calculating last 3 months enquiry percentage

=Count({<FYear=,LOCAL_CURRENCY=, fMonth=, CalanderQuarter=,SERVICE_LINE={'EXP','WCM','OM'},CalendarDate ={">=$(today()-90)"}>}  DISTINCT ENQUIRY_ID)

/Sum({<FYear=,LOCAL_CURRENCY=, fMonth=, CalanderQuarter=,SERVICE_LINE={'EXP','WCM','OM'},CalendarDate={">=$(today()-90)"}>}  E.TARGET)

The problem is that this expression does not work

Please help

Regards,

Nadeem

[fashid]

Hi Peter,

I used the following expresssion

Count({<DateNum ={">=$(NUM(today())-90)"}>}  ENQUIRY_ID)

So there was just a small problem of selecting the right field i.e DateNum.

Thanks or all your help and pointing in the right direction

Regards,

Nadeem