

Partner - Specialist
2021-05-12
11:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display a value for a dimension with 1 decimal place
Hello,
I have a requirement to display Gloves with 1 Decimal Place and Jeans with 0 Decimal places.
Looking for some suggestions.
Thank You,
Michael
1,176 Views
1 Solution
Accepted Solutions

Specialist III
2021-05-12
12:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could create a table
FMT:
load * inline[
Product,FMT
Jeans,'#.'
Gloves,'#.0'
];
Still set the Number formatting to expression,
Num(Sum(Amount),FMT)
1,134 Views
3 Replies

Specialist III
2021-05-12
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set the measure "Number formatting" to Expression. In the measure
=If(Product='Jeans',Num(Sum(Amount),'#.'),Num(Sum(Amount),'#.0'))
1,148 Views


Partner - Specialist
2021-05-12
12:00 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
That is what I thought.
I don't like to use if statements because it may slow things down. Is there another solution?
Michael
1,142 Views

Specialist III
2021-05-12
12:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could create a table
FMT:
load * inline[
Product,FMT
Jeans,'#.'
Gloves,'#.0'
];
Still set the Number formatting to expression,
Num(Sum(Amount),FMT)
1,135 Views
