If you want to save the formatted version as a separate attribute, you can use the following functions to format your decimals:
https://docs.mendix.com/refguide/parse-and-format-decimal-function-calls
For showing things on pages, you can use the formatting section:
Hi Saeeed,
You can use the following function inside a microflow, which can be called either inside the source microflow for the page.
formatDecimal( NumberAttribute, '¤ #,##0.00') This will even get you the currency symbol based on the user setting.
This will return a string variable that you can use to display.
Another option is to use a calculated attribute and use the above microflow in a before commit event
Thanks,
Shekhar
Hi Saeed,
I think it’s depend upon the language setting. Please refer the below document for the details.
Check the section 3.3 Microflow Examples from the below link.
https://docs.mendix.com/refguide/parse-and-format-decimal-function-calls
Thanks
I crreate this microflow:
whit this Variable:
But doesn’t work
Hey ,
If you want ta appear it at datagrid or dataview double click the control then go to the formatting and put them like the bellow:
this is for data grid:
this is for data view :
Hope that will be helpful .