How do I display "$" sign in KPI object and also use Numerical Abbreviations ("K", "M", "B"...)
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.