
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
get rid of decimal points
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try Num(ACT_GBP.Materialty, '#0%') ?
IF not can you share some sample data please.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
floor(if( [Data Category]='Adjusted',
Num(ACT_GBP.Materiality, '##%')))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try Num(ACT_GBP.Materialty, '#0%') ?
IF not can you share some sample data please.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That was exactly it
THanks
