In my report I have 2 groups. Group 1 is the person and group 2 is the charge code.
I want to calculate the workload value for each charge code for each person and the total workload value for that person.
I have the following formula: The first converts a string to a number
RVU Number =
if IsNumeric ({WorkloadDefinitionTable.Units})
then ToNumber({WorkloadDefinitionTable.Units}))
The second one I use to calculate a workload value per chargecode
Workload Value =
{@RVU Number}*DistinctCount ({SpecimenChargeSlipTable.ObjectID}, {SpecimenChargeSlipTable.Code})
Now I want to add all the workload values for the charge codes for each person into a total workload per person. Crystal does not allow me to summarize the workload value formula. I tried
Sum ({@Workload Value},{@Grosser} )
but get an error that the @workload value cannot be summarized.
How can I accomplish what I want to do? Thank you!
