Set Analysis with Operators

[gavthomson]

Hi All,

A little stuck and it seems easy but for some reason I cannot get it to work.  The formula is supposed to 

1. count IDs between age 0 and 26 (which it does fine) and

2. Ignore the selection of the field Date.YearMonth (which it does not do fine!)

Count(distinct {(<[Age (Years)]={"=[Age (Years)]<26"}> * <[Age (Years)]={"=[Age (Years)]>0"}>) * <[Date.autoCalender.YearMonth]=>}
[Identifier])

Help please, it's driving me mad!

Regards

Gav

[sunny_talwar]

Try this

Count(DISTINCT {<[Age (Years)] = {">0<26"}, [Date.autoCalender.YearMonth]>} [Identifier])