Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi
in number tab
select fixed to -2 decimal places
then it give upto 2 decimal places only
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.
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.
Perfect. Thank you.