4 Replies Latest reply: May 4, 2009 9:43 PM by John Witherspoon RSS

    Chart Expression Normalization Error


      I've got a bar chart that shows recommendataions 1 and 2 out of a possible 1 through 5, by gender, so there are two dimensions (gender and rating). Now I need to normalize the values..

      This expression gives the count: If(Recommend<=2,Count(Recommend)) and this is the normalization: If(Recommend<=2,Count({1}Recommend))

      Both expressions give correct values if they are charted independently, but if I combine them on a single chart to do the normalization, they do not: If(Recommend<=2,(Count(Recommend)/Count({1}Recommend))*100)

      Any suggestions? Thanks, Tom