1 Reply Latest reply on Mar 3, 2016 10:42 AM by Derrick Austin

    Custom Number Formatting (Representing Millions and Grands)

    Romil Shah

      Hi,

       

      I am using below formula in Custom Number format field. It seems to be working perfectly fine for values greater than 1 Million.

       

      However, it is not working for values greater than 1K but less than 1M. According to me second argument should be invoked in case of values greater than 1K and less than 1M, but it doesn't seem to be working.

       

      Each time a value is less than 1M and greater than 1K, last argument is called (which should to be called only in case of values less than 1K)

      [>=1000000] $#,0,,;[>=1000]$,#0,"K"; $0

       

      Can someone please help?

       

      Regards,

      Romil