Percentage format, eMail body, TEXT Function

Anaplanners,

Running into a rather simple issue, wanted to use the anaplan mail to function with the body picking up few data from the module, for example: -

Marks obtained by each student is stored in line item called 'STUD1.1 Student Details'.Marks
Marks Obtained = 70%

Now my mail body formula would be "Marks Obtained = " & TEXT('STUD1.1 Student Details'.Marks)

However, the result returns

Marks Obtained = 0.7

Is there a way i can display the same in percentage format. Directly referring without using TEXT function returns error, since Text & Number cannot be concatenated.

Thanks for the help

Accepted answers

Akhtar.shahbaz

Hi @Sachinsourav02

Just multiply by 100and add percentage sign at the end

All comments

M.Kierepka

Hi @Sachinsourav02,

Not so easily, but with just a little transformation you can achieve the result that you want, like:
"Marks Obtained = " & RIGHT("0" & TEXT(ROUND('STUD1.1 Student Details'.Marks * 100,0,NEAREST,EXACT)),2) & "%"
Explanation:
1. You can firstly multiply number *100, to have a whole number, so in your case 70.
2. Then you use TEXT function on it to get a string, and you can concatenate it with "%", so you arrive to "70%"
3. Depending on if you want "5%" to be displayed as "5%" or "05%", you can also do things like RIGHT("0" & TEXT(Num)),2).
4. You probably also need to apply ROUND() function (and test it!) for cases like "not whole percentages" or "rounding inaccuracies".

Akhtar.shahbaz

Hi @Sachinsourav02

Just multiply by 100and add percentage sign at the end

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385