2 Replies Latest reply: Sep 16, 2018 11:15 AM by Quy Nguyen RSS

    How do I display "$" sign in KPI object and also use Numerical Abbreviations ("K", "M", "B"...)

    Brian Droesch

      Hi,

       

      I am showing a KPI for a monetary field where I want to show it with a numerical abbreviation. For example, 1.5B instead of 1,500,000,000. I added the following statement to my load script to set 10^9 as "B".

       

      SET NumericalAbbreviation = '3:k;6:M;9:B;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:µ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

       

       

      This works when I set the formatting to "Auto" but I want to add a "$" to the beginning of this value.  How would I do this? If I change the format to MONEY then I lose the abbreviation.

       

      I imagine there is a way to do this with setting a Custom formatting. Please let me know if there are any such solutions.

       

      Thank you,

      Brian