Calculate Rate

[agebre]

I have one query item in my report: MEMBER STATUS. MEMBER STATUS have 'ACTIVE' and INACTIVE' values.

I am trying to display ACTIVE MEMBER RATE in my report. (ACTIVE MEMBER RATE = count of only ACTIVE members/Count of ACITIVE and INACTIVE members).

I am trying to do something like this ...(COUNT (MEMBER STATUS) When MEMBER STATUS = 'ACTIVE') / COUNT (ALL MEMBER STATUS).

Does anybody know how I can do this?

Thanks,
Ambex

[Blue]

Try creating another item in the query:

IF (MEMBER STATUS='ACTIVE') THEN (1) ELSE (0) and call it ACTIVE STATUS

Set the aggregation rule on this and the MEMBER STATUS item to COUNT. This will give you only one row with 2 numbers - the count of members and the count of active members.

On the page create a layout calculation something like ACTIVE STATUS / MEMBER STATUS.  This will create a third item on the row which is the percentage of active members.

Hope that helps. 

Blue