Trying to keep the 0 after a decimal place in a numeric field eg. 1.10 1.20 etc
Numeric fields automatically remove the 0 at the end of a numeral with a decimal place, so 1.10 will become 1.1 but I want it to stay as 1.10.
Forum Discussion
np
Edit the field properties and set the # of decimals to 2
Edit the field properties and set the # of decimals to 2
not tested but you woul;d need this extra line
var text Millions = If(Abs($Value)>=1000000,ToText(Int(Abs($Value)/1000000)));
and then
.....List(",",$Millions, $Thousands,$Hundreds) & $Decimals)
var text Millions = If(Abs($Value)>=1000000,ToText(Int(Abs($Value)/1000000)));
and then
.....List(",",$Millions, $Thousands,$Hundreds) & $Decimals)