Pages:
Actions
  • #1 by Oxa (WellDoneSoft) on 19 Jul 2013
  • Copied from a support request:

    Quote
    hi, in my trigger i need to insert a formula into the field "Amount" (see the picture attached) . In formula builder i have tried my personal idea , but i don't know if the trigger will understand it (because of eventual syntax error) .

    What the trigger has to do? If number of losses is 0, continue using the default_laya , if number of losses is <3 then use the formula (last_lost*1.10) , if number of losses is >=3 then use a stake of € 0.01 . When the trigger see a won, return to default_laya.
  • #2 by mcbee on 20 Jul 2013
  • hi
    it should be.
    IF(AND(losses>0,losses<3),last_lost*1.10,IF(losses>3,0.01,default_laya))


    mcbee
Pages:
Actions