2 Replies Latest reply: Sep 3, 2013 7:17 AM by Or Shoham RSS

    Alternative for shorting large numbers in Graphs

      Hello,

       

      I am using the following code in my graph so numbers larger then 1000 will appear as 1K.

       

      if(Sum([EndOfWeekStock]) > 1000,
        Num(Sum([EndOfWeekStock])/1000,'#.#0K'),
      Sum([EndOfWeekStock]))
      

       

      However, I sometimes have numbers larger than 1000 and smaller mixed. This results in really small values compared to the ones below 1000.

       

      Is there another way to accomplish this?