Straight Table Multiple number formats

[vardhancse]

Hi,

Have one requirement is that, one staright table dimension value should have multiple number formats.

For eg:

#,###.0

#0.00%

Can please do the needfull.

[sasikanth]

HI,

based on any conditions ? if so please specify

[swuehl]

You can check the dimension value and apply different formats using num() function in the expression, keep the number format on number tab to 'expression default':

=Num(

      Sum( Amount),

     Pick(Match( YourDimension, 'A', 'B'), '#,###.0','#0.00%')

      )

[vardhancse]

Hi,

No conditions, some thing similar to below table:

Dim	Actual	Plan
Dim1	10.3	10.42
Dim2	20%	30%

now for Dim1 the format is

#,###.0

and for dim2 the format is

#0.00%

[sasikanth]

HI,

Try like

If(Dim='Dim1',num(Sum(Actual),'#,##0.0'),num(Sum(Actual),'#,##0%'))

i dont think it will work if we have many values

Please share your  sample file

[vardhancse]

Hi,

Thanks for your reply,

By using above condition only 1 dimension number format was changing not all.

can please let me know that I am doing right.?

[swuehl]

Could you upload a small sample QVW?

[sunny_talwar]

Using Stefan's technique:

Expression: =Num(Sum(Actual), Pick(Match(Dim, 'Dim1', 'Dim2'), '#,##0.0', '##%'))

=Num(Sum(Plan), Pick(Match(Dim, 'Dim1', 'Dim2'), '#,##0.0', '##%'))