Formula

[#1]

Hi all,

I need to compare 2 figures at an individual record level, and aggregate them at a higher level.

For example, I want the total number of people per state whose age is less than their height in inches.

so far, my attempts at drafting a formula in QV to create such a comparison have worked for only those states with just one person in them (who happens to be younger than their height in inches).

can someone help direct me to find the proper formula?

thanks!

[#2]

Have you tried something like

sum(if (AGE < HEIGHT , 1, 0 ))

[#3]

that worked, thanks! I was using the count formula.....