Number format - formular correct but displays incorrect

[MichaelDee]

Hello, 

Can someone please help me with this?
I believe I have the right formular to show the value as "35.000" (in Denmark the punctuation is 1000-separator).

It does show the right value under the formular på not on the card.

Thanks!

Michael

[poweractivate]

Check these examples:

Text(Value(35.000,"pt-BR"),"##.000")

Text(Value(35.123,"pt-BR"),"##.000")

See if this works better for you.

Also see documentation on Text function for more info.

[MichaelDee]

@poweractivate Thanks, however, I still don't see the right format on the canvas:

I pull the data from a MS List, where the field is defined as number.

[v-qiaqi-msft]

Hi @MichaelDee,

Try as below:

Text(Value(Parent.Default);"[$-pt-BR]#.###,##")

[MichaelDee]

@v-qiaqi-msft Thanks, however, i still don't see the right format on the card.

BR

MichaelDee

[v-qiaqi-msft]

Hi @MichaelDee,

Could you please check the format property of the Text Input?

Make sure that the Format is Number type.

[MichaelDee]

Hi @v-qiaqi-msft 

The Format is blank. When I mouse over I see that it is formatted by the formular (Text(Value(Parent.Default);"[$-pt-BR]#.###,##").

In the Microsoft list (where this field is pulled from) it is defined as a number.

Thanks!

Michael

[v-qiaqi-msft]

Hi @MichaelDee,

Could you please format it as Number and check if it works?

[MichaelDee]

Hi @v-qiaqi-msft Thank you for your effort to solve this. However, you're suggestion on formatting as a number is where I came from. The standard number format doesn't provide any additional formatting, I will see the number as "35000" instead of "35.000" (in Denmark or US "35,000").

Thanks Michael