Can you have more than one variable in a field calculation?
Currently, I have a calculation that says:
Field B =
If ( FieldOne = FieldTwo; FieldA-1; FieldA)
So, if B = 4, and FieldOne and FieldTwo have the same number input, then FieldA shows a 3 - which is fine, that's what I'm after.
But, I need another variable stating that
If ( FieldOne > FieldTwo; FieldA-2; FieldA )
So, if B = 4, and Field One has a higher number input than Field Two, then FieldA would show a 2.
I can get the calculation to work with only the first formula but if I ask it to evaluate both "Ifs" I don't get the correct calculation. I thought all I had to was put in both calculations with " or " between them, but that doesn't work.