% Sign for numbers
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, is there a simplified way to make decimal places (it has to be a number as it is calculated in the formula tool) into percentage signs and narrow down to 2 decimal places (can this be double too? if not, string is fine too) . I have created the following but thought this is too complex as i need to apply this on multiple parts of the workflow.
I tried fixed decimlas 19.2 but not really narrowed down to 2 decimal places.
Solved! Go to Solution.
- Labels:
- Best Practices
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you asking for this? Mutiplied by 100 then rounded to 2 d.p. with the 0.01 parameter after round. Forced it to string so i could concatenate the % sign afterwards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
Sorry coming back to this. How can i make the percentage sign into a number after forced it to string? I use select tool to make it a double but the percentage sign disappears.
