add a text value to an expression

[alec1982]

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,

[MayilVahanan]

Hi,

     Avg({1} if( [Status] = 'Active', [Sales])) & 'Milllions'

     You can use in straight table or pivot  table instead of others chart.

     or

     in chart you can use properties ->Number ->MillionSymbol(M) and display in axes.

Hope it helps

[alec1982]

Thxs,

Where i need to sho the days vaue is: when you hiber with the mouse on top of one of the bars alttile window shows up and shows the dimenssion and expression. I need to show the Millions next to the value on this window.

Thxs

[swuehl]

Try using a dual value as value returned from your expression:

dual(

Avg( {1}

    If (

        ([Status] = 'Active')

        , [Sales]

        )

    ) & 'Millions'

,

Avg( {1}

    If (

        ([Status] = 'Active')

        , [Sales]

        )

    )

)

[MayilVahanan]

Hi,

     Try this,

       Num(Avg({1} if( [Status] = 'Active', [Sales])),'#,##0(Millions)')

     Hope it helps

[alec1982]

hi,

thxs for the answers.

both ways show me the 'millions'  on values on data point and on the mouse box(when i hiber on top of one of the bars.

Is there anyway I can show the text ONLY on the box that appear when i hiber with the mouse on top of one of the bars.?

Thxs,