4 Replies Latest reply on Nov 5, 2017 5:14 PM by Pasle Choix

    Customize number format in label

    Pasle Choix

      Hello,

       

      Can anyone tell me how can I transform the "Trans" from full digits number to human-friendly format like B, M, K? for example for the first item BAC, its trans is 15,573,043,500 which I want to show 15.573 B, while for the last item PFE I want to show 3,992 B

       

      This is a test I did on Label and Tooltip:

      <Name>:<SUM(Trans)>/100000000

       

      It doesn't do the actual math calculation, why?

       

       

      Thank you in advance.