Number format

0
Hi All, How can i change the Format of Decimal? I need german format like : 123.456.789,00. Soll i do that with Microflow ? How? Thanks
asked
5 answers
0

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:

https://docs.mendix.com/refguide8/text-box?utm_source=businessmodeler&utm_medium=software&utm_campaign=modeler#formatting

 

answered
0

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

answered
0

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

answered
0

I crreate this microflow:

 

whit this Variable:

But doesn’t work

answered
0

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 .

answered