get rid of decimal points

[bobbydave]

I have a Calculated Dimension and if i could use a number function from the Number tab, it would work. However, there is none.

But my dimension below is

if( [Data Category]='Adjusted',

Num(ACT_GBP.Materiality, '##%'))

This gives me decimal points.

I'm trying to bring back figures without decimal points in percentage form.

By asking for num ##%, i know when i will get 2 numbers back, either to one decimal point if 8.2 and no decimal point if double figures like 20 or 40.

How can i just get whole numbers?

[vvvvvvizard]

floor(if( [Data Category]='Adjusted',

Num(ACT_GBP.Materiality, '##%')))

[vishsaggi · Accepted solution]

Did you try Num(ACT_GBP.Materialty, '#0%') ?

IF not can you share some sample data please.

[bobbydave]

That was exactly it

THanks