Millions with single decimal value only

[bushpalaamarnat]

Hi All,

Following is the formula used in dimension to create the table chart.

=NUM(AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)

-

Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND),'###,###,###.')

the output i get is 456,456 for example.

Kindly advise, i need the out put as 0.4(M)

Could you advise how to amend the formula.

[Frank_Hartmann]

Maybe like this:

floor(AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)-Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND),100000,100000)/1000000&'(M)'

[prat1507]

Hi

Probably this

=NUM((AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)

-

Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND))/1000000,'###.# (M)')