I am calculating average costs, and need to determine the maximum "average cost."
I have average costs calcuating per group, and want to determine which one is the greatest. Everytime I try to find the average on a calcualtion, I get an error message, "Field cannot be summarized." Is this even possible?????
Maximum ({@AverageCost})
@AverageCost = {@TotalPrescriptionCost}/{@TotalPrescriptions}
{@TotalPrescriptionCost} = SUM({@PrescriptionCost},{@MedicalDirectorName})
{@TotalPrescriptions} = count({Billing.DrugName}, {@MedicalDirectorName})
THANKS!!!!!!!
Kelly
I have average costs calcuating per group, and want to determine which one is the greatest. Everytime I try to find the average on a calcualtion, I get an error message, "Field cannot be summarized." Is this even possible?????
Maximum ({@AverageCost})
@AverageCost = {@TotalPrescriptionCost}/{@TotalPrescriptions}
{@TotalPrescriptionCost} = SUM({@PrescriptionCost},{@MedicalDirectorName})
{@TotalPrescriptions} = count({Billing.DrugName}, {@MedicalDirectorName})
THANKS!!!!!!!
Kelly