@Text(currency; "C,2")

HCL Domino Domino Forum
1

Hi Guys

Ive users @Text(Field; “C,2”) where FieldType = Text and Computed, to convert some fields on a form to currencies.

It works 100% except for the fact that i neglected to overlook the regional locale settings of some machines. Hence, i end up with $19.99 instead of R19.99 etc…

Now, my idea is that the default values for these fields are @Text(Field; “C,2”)… which should force them to change on document refresh? Guess what… they dont! I’ve tried refreshing the document manually (F9), tried in a view using @Command([ToolsRefreshSelectedDocs]) and still no luck. My regional settings are correct because when i create the document it displays the correct currency value.

The only way i can get the fields to change and reflect the correct currency value is to manually change it!

Please help :frowning:

2

Subject: @Text(currency; “C,2”)

hey you write this also

@Command ([RefreshHideFormulas])

so that fields will get refresh …

i hoe it will help you

3

Subject: @Text(currency; “C,2”)

Why are you convert the numbers to Text? If you left them as numbers, wouldn’t this fix your problem?

The problem with your solution is if you ever want to do a calculation with those numbers or display them on another machine with different regional settings you’re going to run into problems.

For example if someone in France enters 19,99 - then someone in the U.S. is going to be confused why there is a comma there and if you have a field that is the sum of these values - it will give an error.