4 Replies Latest reply: Apr 26, 2013 2:27 AM by Snehal Nabar RSS

    Format for displaying negative numbers in ()

    Sonika Jain

      Hi all,

       

      In one of my requirements, I need to display negative numbers in brackets for  specific rows. I am using 'IF ' for this in expressions and the num () function - with format '#.#%;(#.#%), but it is giving me discrepnacies in result as in -

       

      for Num (-1.4,'#.#%;(#.#%)')   result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%

       

      Please help me on this.

       

      Sonika