We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
Hi All,
I'm trying to change % from decimal to non decimal expression, I've tried to use Num/Format functions but to no avail, example below. I'd like to see 5% and 2% instead 5.4% and 2.1%.
The expression I'm using:
Attachments (1)
Expression KPI.png
2.71 KB
0 Votes
Emma Camacho posted 6 months ago Admin Best Answer
Hi Jaroslaw,
Please enclose the num expression with the text function, something like this:
"KPI 1" & [Datasource].[your_datasource].[Expression].[ text( num( ... ) * 100 ) ] & "%"
With the text function you force M&D to use the text representation of the number, as M&D will always try to display the numeric version of the number.
Let me know if this helps for you,
regards, Emma
0 Votes
1 Comments
Emma Camacho posted 6 months ago Admin Answer
Hi Jaroslaw,
Please enclose the num expression with the text function, something like this:
"KPI 1" & [Datasource].[your_datasource].[Expression].[ text( num( ... ) * 100 ) ] & "%"
With the text function you force M&D to use the text representation of the number, as M&D will always try to display the numeric version of the number.
Let me know if this helps for you,
regards, Emma
0 Votes
Login or Sign up to post a comment