Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Count(DISTINCT {<[Age (Years)] = {">0<26"}, [Date.autoCalender.YearMonth]>} [Identifier])