IIF Function based on a Value and a Calculation
Posted on 2013-07-01
I have two fields; One that has a static number from a linked report and the other which I created based on Calculations from two other fields.
I created a IIF Statement: Odd Match: IIf([Speed 1]=[Speed 2],1,0)
Speed 1 is the static number and Speed 2 is the calculated field based off of two other fields.
They are all set as numbers, yet they are not agreeing.
Do you have any suggestions of what I should look for?
Feeling a little dumb right now...