Question
display results with % sign
+6- Contributor
Hi, I am calculating a average age and I would like the results to display with the % sign. I got the number that I wanted but it's displayed as text (42) and not a number. I would like to display as a number with % sign. Is that possible for FME to do.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
If you are looking for how to define the format for percentage representation in the Excel writer, try set "0%" to the Custom Number Format field for the column.
(FME 2015.1)
Takashi
+6- Contributor
How do i access this Edit Coumn Formatting window. I am not able to see it when i click on my writer
The GUI has been changed in FME 2015.1.
In FME 2015.0, select "Custom" (forgot correct choice string...) in the Format type, and then enter "0%" into the "Custom format string".
I'm not sure whether this works as expected in FME 2015.0. If possible, it's better to upgrade to FME 2015.1.1.
+6- Contributor
Ok, it worked i had to change the type to Number from Auto. But now it shows up as 4200% instead of 42%. is that possible to change it?
Excel displays 100 times of the value if the cell format is percentage. It's a specification of Excel.
You can divide the value by 100 using ExpressionEvaluator or AttributeCreator, before writing.
+6- Contributor
finally, it worked. thank you so much Takashi. I used ExpressionEvaluator and /100 and then on the writer i had to take the 0% off and leave it to read it as a number. In excel that number was then read as %.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.