jeudi 10 janvier 2019

SSRS IIF statement PEMDAS issue

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