6 Replies Latest reply: Mar 14, 2017 4:11 AM by dineshraj ramesh RSS

    Prefix in KPI

    dineshraj ramesh

      Hi Experts,

       

      I need to add '$' symbol before my measure. I get the output by using this Expression.

       

       

      pick(ceil(log10(sum(Sales))/3),

                num(sum(Sales),'#,##0.0'),

                num(sum(Sales)/1000,'#,##0.0 K'),

                num(sum(Sales)/1000000,'#,##0.0 M')

           ) & ''


       

      (This is answered by Gysbert Wassenaar)
      But i can't get the conditional Colors
      Could anyone help
      Thanks in Advance