1 Reply Latest reply on Apr 22, 2019 11:37 AM by Deepak Rai

    If Number is Greater than, divide

    zain.lone

      Hi,

       

      I currently have a view of product prices. Ideally if a product's price is greater than $4.00, we need to then show a calculation of that price divided by 12%. On the flip side, if the price is less than $4.00, we need to then divide that price by 5%.

      Would a CASE statement or IF statement resolve this?

       

      Thank you.