COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 14 Mar 2012 03:47:23 PM

Title: count function?
Post by: sravantig on 14 Mar 2012 03:47:23 PM
State       Turnover rate
ABC               20.34%
DEF                31.4%


What would be my expression to count the number of states which have turover rate less than 20%?
Title: Re: count function?
Post by: sravantig on 14 Mar 2012 04:23:11 PM
It's a DMR model, my states are a hierarchy level set and turover rate is a measure