2 Replies Latest reply on Mar 18, 2016 12:53 AM by Niranjan Banarjee

    Concatenate if

    Niranjan Banarjee

      Hi,

      Can anyone help me in the below situation?

       

      In the below table i have calculated row % and the red font numbers are more than 10%. Now I want the Promo Price & more than 10% to be combined.

      For example, in the 1st column- output should  be 1.99,12.4%.