Can number formats be changed dynamically?

[ljdlumley]

I have a table giving results for a few years, averages, max values etc for data that changes depending on which Key Performance Indicator is selected from an inline table.

For some KPIs it makes no sense to see any decimal places (Total spend in £) and others I want to see down to 2 decimal places as the figures are small numbers 0.13, 0.16 etc that need displaying.

Is it possible to do what I'm after?

thanks

John

[#2]

Hi

in number tab

select fixed to -2 decimal places

then it give upto 2 decimal places only

[jagan · Accepted solution]

Hi,

PFA file, hope it helps you.

Try this expression

=If(Profit% < 1, Profit%, Num(Profit%, '###,#0'))

and in Number tab set Number format settings to Expression Default

Regards,

Jagan.

[ljdlumley]

Hi, that is ok for a normal table but my table will show different data depending upon other selections.

If Measure 1 is selected in another list I want the table to be 0 decimal places. If Measure 2 or 3 is selected then I want the table to be 2 decimal places, Measure 4 1dp and so on.

[ljdlumley]

Perfect. Thank you.