Calculated Field coming up as invalid

[jjsande1492]

Hello.

I am trying to create a calculated field in a table to count the number of blank fields for each record. However, every iteration of the calculation I do comes up as invalid.

I've tried:

IIf(IsNull([SKU])=True,1,0)+IIf(IsNull([Part_Number])=True,1,0)+IIf(IsNull([Description])=True,1,0)

and

IIf(IsNull([SKU]),1,0)+IIf(IsNull([Part_Number]),1,0)+IIf(IsNull([Description]),1,0)

and

IIf(Len([SKU])=0,1,0)+IIf(Len([Part_Number])=0,1,0)+IIf(Len([Description])=0,1,0)

What am I doing wrong?

Thanks!

[jjsande1492]

Update:

It appears that a data macro I had on the table was preventing the calculated field from working. The macro prevents updates to a record if one field is populated. Removing this macro allows the new field to calculate.