5 Replies Latest reply: Jul 6, 2012 11:40 AM by Alec Harf RSS

    add a text value to an expression

    Alec Harf

      Hi,

      I am trying to add a text value to an expression to show up.

      Avg( {1}

          If (

              ([Status] = 'Active')

              , [Sales]

              )

          ) & 'Millions'

       

       

      The value that i want to add is the Millions and wheneverI add it, the chart shows no data.

      Any help,

      Thxs,