Sum Calculated field with IIf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Net1: =([Hrs_Wkly_Unpd_DDT]-[Total_Absence])
Net2: =IIf([Net1]<=0,"0",[Net1])

I want to sum Net2
=Sum(IIf([Net1]<=0,"0",[Net1]))

receive an error message asking for Net1 value.
 
Try this:
Net2: =IIf( ([Hrs_Wkly_Unpd_DDT]-[Total_Absence]) <=0,0,[Net1])

NOTE: your expression should not return "0" as this is a string when you
really should be returning a number. You shouldn't mix your data types.
 
Back
Top