This topic contains 2 replies, has 0 voices, and was last updated by mhambalek 8 years ago.

  • Author
    Posts
  • #9771

    mhambalek

    I need to have a workflow state trigger when a sales order’s new total is greater than $5000 plus the old total OR if the new total is 110% greater than the old total. This condition statement isn’t working: ({total}>(5000+{old.total}) or ({total}>(1.1*{old.total})

    Individually the two statements work. Should I be using a CASE statement here? Thanks for the help!
    This is a cached copy. Click here to see the original post.

  • #9772

    markluu

    Hi mhambalek,

    I tested this on my end and it seems to work. The difference mine has with you is the brackets at the end. See below:

    ({total}>(5000+{old.total}))or ({total}>(1.1*{old.total}))

  • #9773

    mhambalek

    Thanks. I see I was missing some parenthesis. Working for me now too.

You must be logged in to reply to this topic.