This code
=iif(sum(Fields!TOTAL_HOURS_wo_BREAK.Value) - sum(Fields!TOTAL_TIME_INDIRECT.Value) > 0, (sum(Fields!TOTAL_UNITS.Value)/sum(Fields!TOTAL_HOURS_wo_BREAK.Value) - sum(Fields!TOTAL_TIME_INDIRECT.Value)), 0)
needs to divide the field "Total_UNITS" by the sum of the field "TOTAL_HOURS_wo_Break" minus the field "TOTAL_TIME_INDIRECT"
I feel like my PEMDAS is off in the divide portion.
Aucun commentaire:
Enregistrer un commentaire