7 Replies Latest reply: Mar 9, 2018 9:26 AM by Colm Kelly RSS

    How do you dynamically set a number format in a linechart

    Colm Kelly

      Hi everyone,


      I have a line chart where I want to set the number format dynamically based on a variable.


      For my measure I want to be be able to toggle between Num(Sum(Sales), '0.000') or Num(Sum(Sales), '$#0.00')


      Both of these measure work individually. However, when I put them in an if statement, the number format stops applying:


      If( True(), Num(Sum(Sales), '0.000') , Num(Sum(Sales), '$#0.00'))


      Does anyone have any idea how I can get this resolved?


      Thanks in advance