1 Reply Latest reply on Dec 1, 2018 10:27 PM by Ombir Rathee

    Converted Millions and K's dynamically but object changed to discrete measure i dont want to change measure type (continus measure)

    rao marapatla

      Hi All,

       

      attached workbook v10.5

      I can able to convert values as Millions and K 's with IF statement  since its if its showing as  Discrete measure but I wanted to see this as Continues mesure as I have futher calculation with converted measure

       

      can you suggest else please suggest if there any alternative way to achive this without changing Sales datatype.

       

      and also wanted to elimante last row with 0

       

      attached workbook.

       

      Goal: without changing object type wanted to display M and Ks

      m and k.JPG