1 Reply Latest reply on Jul 8, 2015 8:26 PM by Bill Lyons

    Automating the Units

    Siddharth Gupta

      Hi, 

       

      I need to create a calculated field which will automate the Units of the number. For Eg: If for all the data the Units are in Billion, I want this “Billion” to be replaced automatically by  “Million”, “Thousand” or whatever is relevant after applying the filter through parameter. So, currently what is happening is, if I change a parameter and the number comes out to be very small, I see 0.0B which gives no information.

       

      Please suggest any solution to this problem.

       

      Thanks,

      Sid