3 Replies Latest reply on Jun 20, 2018 7:50 AM by Mavis Liu

    adding millions "MN" or billions "BN" at the end of a number in calculated field

    sowjanya kolluru

      Hi,

       

      I have a set of values for a particular dimension which need to be custom formatted using calculated field. so was using the below formula and it works fine to change the value to millions.

      But, now I wanted to add "mn" or "bn" for the end user to understand whether the value is in millions or billions. so,how can I add the suffix or prefix to the below formula. please advise.

       

       

      SUM(IF CONTAINS([KRI Name], "INDEBT_SEC") then ([KRI Value])/1000000

      ELSEIF  CONTAINS([KRI Name], "INDEBT_UNSEC") then [KRI Value]/1000000 END)

       

       

       

      thanks

      Sowjanya