Expressing calculation result as a percentage
- 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
Is it possible to express result of a calculation as a percentage value? For example, if division is used: 2:5=0.5 to show it as 50%. I am aware that % sign can be added via concatenate. But is there an easier way of doing it?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unfortunately not whilst keeping a numeric data type or anything. The best way to go about this is do what @Sebastiaandb has done and calculate the value whilst turning it into a string before adding %. Just be careful - you need to multiply that result by 100 to get it as a true percentage:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hey @Nickolay
I agree with @Sebastiaandb on this one.
Another quick way to do it if you are you going to be outputting your results using a table tool from the reporting pallet is by using the prefix functionality shown below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot all! It works for me 😀
