Hi everyone, i have a major issue with the sc macro sc_trunc_num().
So the sc macro sc_trunc_num(), is used to truncate numerical values that exceed the decimals amount specified. That being said if you have a number like 1250.23 and you use the sc_trunc_num({field}, 4) macro, the new number will be 1250.2300
But this works for regional settigns like UK and countrys that uses the numbers like this:
50.00
125.20
50,000.00
But in some other countrys… like Greece we use numbers like this:
50,00
125,20
50.000,00
And i can’t really use the sc_trunc_num() which i really need it or use maybe the Number_format()…
I have tried to use the Number_format() but scriptcase returns error for not wrong data… because the decimal field is set to “Decimal Precision” to 0
Because the decimal field in scriptcase does not let me convert the decimals the way that i want…
All i want is the user to write-define how many decimals he wants, and then my application will convert them… I really don’t know how to do it.
Any advice ?