Announcements
Hello,
I'm new with PoxerApps and i wonder how to show the result of this fonction
ThisItem.PA_UNIT & " €"
only 2 decimals
Thanks for you help
Loadlucas
You can use the Text function to convert a number to a text with an appropriate number of decimals, like in the example below:
Text(ThisItem.PA_UNIT; "0,00") & " €"
Or if the decimal separator for your language is '.', then you'd use this expression:
Text(ThisItem.PA_UNIT, "0.00") & " €"
Hi,
Thank you for your response.
The fonction have no error but nothing happend.
It show always decimals ... Any idea ?
Thank you
I see that the value is being shown with a '.' as the decimal separator. since your language seems to be French, numbers would typically be shown with the ',' separator instead. Is the type of PA_UNIT string (text)? If so, then you may need to first convert it into a number (you can use the Value function for that), then use the Text function to write it with the desired number of decimal places. The expression would be something along the lines of
Text(Value(ThisItem.PA_UNIT; "en-US"); "[$-fr-FR]0,00") & " €"
Thanks !
Exactly what i wanted
Thank you very much !
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
