### Title

multiply field value if it has four decimal places

### Post

Hi,

I'm trying to create a calculated number field named "RESULT" the reference number field is "AREA" which contains values measured in hectares and sq.m. without symbols. Now i want to happen is if "AREA" value has four decimal places multiply it with 1,000 but if not just return the AREA value.

Thanks...

1.0000 and 2.0000 aren't numbers and they have not 4 decimal.

BTW: try: