4 Replies Latest reply on Jan 4, 2017 10:10 AM by AitchB

    Script using if will not work.

    AitchB

      Good evening and a Happy New Year to you all.  This is my first post here!

       

      I have these fields, from the same table, on my layout:

      Type - Text, Pop up Menu, value list of which 1 is "Compte a Compte".

      Amount - Number, entered freely.

      Amount2 - Number, calculation. (Only to be used if Type is « Compte a Compte » result: Amount2 is the credit or debit of the sum in Amount. i.e. Amount x -1. if not amount 2 must be 0)

       

      My script:

      If ( Type  =  "Compte a Compte" ; Amount2 = -Amount; Amount2 = 0 )

       

      I also tried:

      If ( Type  =  "Compte a Compte" ; Amount2 = Amount* -1; Amount2 = 0 )

       

      and it doesn’t work!

       

      Any help would be appreciated.

       

      Henry (Novice+)