4 Replies Latest reply on Sep 5, 2012 11:20 AM by philmodjunk

    Can you have more than one variable in a field calculation?

    fmpro_novice

      Title

      Can you have more than one variable in a field calculation?

      Post

       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.