Chart Expression Normalization Error

[#1]

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

[#2]

I've figured out the problem but not the solution. Let's say you have:

10 out of 100 recommendations are 1 or 2, by males, which is 10%

15 out 100 recommendations are 1 or 2, by females, which is 15%

The formulas above calculate the total by adding 10% and 15% for 25%. I really want 25 out of 200 for a total, which is 12.5%

[prieper]

Hi,

can you post an example? Might be a bit easier to look at.

/Peter

[#4]

Example posted, with brief description embedded.

[johnw]

Is the attached what you're looking for?