Hi,
This is on Crystal Report 10 and Oracle data.
I've a report showing rankings based on summaries at this time. However, considering that one person might be absent half the month, the summary gives them awful numbers. The client is asking if it is possible to rank based on the averages instead of total. I checked the helpfile and here, but could not find an answer as to if it is possible.
Example, my TopN ranks based on Emails actioned. Instead, it should rank on Emails actioned divided by total tickets opened (as the total is lower for absent folks). However, in the TopN menu, the formula does not appear as it is not summarized. Is there a way to get my formula to appear in the TopN menu??
Thank you,
Phil
This is on Crystal Report 10 and Oracle data.
I've a report showing rankings based on summaries at this time. However, considering that one person might be absent half the month, the summary gives them awful numbers. The client is asking if it is possible to rank based on the averages instead of total. I checked the helpfile and here, but could not find an answer as to if it is possible.
Example, my TopN ranks based on Emails actioned. Instead, it should rank on Emails actioned divided by total tickets opened (as the total is lower for absent folks). However, in the TopN menu, the formula does not appear as it is not summarized. Is there a way to get my formula to appear in the TopN menu??
Thank you,
Phil