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

    Script using if will not work.


      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+)