1 of 1 people found this helpful
Your calculation uses ATTR([Rate of Pay Type]) aggregate function,
which returns NULL value if MIN([Rate of Pay Type]) != MAX([Rate of Pay Type])
ie rows with different values of [Rate of Pay Type] get aggregated into one Mark.
It is difficult to say without actually looking at the data,
but a common approach would be to calculate [$/hr] as
SUM([Final Rate of Pay]) / SUM([Hours])
The [Hours] field in the denominator could be calculated
at Row-Level using [Rate of Pay Type] as a base field.
Hope this could help.
Thank you so much for your reply, I really appreciate it.