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