Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
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]
)
)
)
Hi,
Try this,
Num(Avg({1} if( [Status] = 'Active', [Sales])),'#,##0(Millions)')
Hope it helps
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,