9 Replies Latest reply on Sep 2, 2012 3:54 PM by Sorbsbuster

    Calculation help

    fmpro_novice

      Title

      Calculation help

      Post

      Can someone tell me what this calculation should look like? I am looking for a calculation for field "y".

      Field "x" is the same as field "y" unless field "a" is equal to or greater than field "b". And then, if field "a" is equal to or greater than field "b" we will subtract 1 from field "y". This will be the end result to field "y."

      In other words, if you input a number in Field "x" - field "y" will display the same number - unless - a number entered in field "a" is equal to or greater than a number entered in field "b". So field "y" will end up being 1 less than field "x" when "a" is equal to or greater than "b".

      Is this as clear as mud? Hopefully, I've explained what I'm after.