I am trying to figure out how to calculate an overage between two fields, and if there is a blank, to force 0, but my formula isn't working. Can anyone help me out?
Overage: IFF(([SumOfQty]-[TotalSets]) Is Null Or ([SumOfQty]-[TotalSets])="","0",([SumOfQty]-[TotalSets]))
Overage: IFF(([SumOfQty]-[TotalSets]) Is Null Or ([SumOfQty]-[TotalSets])="","0",([SumOfQty]-[TotalSets]))