9 Replies Latest reply: Sep 19, 2013 2:11 AM by Paul Yeo RSS

    How to make Discount=0 change to Discount=1 ?

      Hi All

       

       

      I have a Field Discount in my Table

       

       

      When i select BRNAD_P = HAKKO or MITSUBISHI Discount = 0

       

       

      May i know how to make it = 1 ? ( Because List Price * Discount = Net Price , If Discount = 0 , Net price will be zero )

       

       

       

       

      left join    (PRICE)

         

      Load PART_NO_,

       

       

          'USD '& LIST_PRICE as PRICE_LIST,

       

       

        1-Discount as Discount_

       

       

       

       

       

       

      Resident PRICE;

       

       

       

       

      My Question is how to add some more script to below code , so that when it see 0 it will replace with 1 :-

       

       

        1-Discount as Discount_