Using a space in a calculated field

[Anthony31413260hlxw]

Hi,

I'm working on calculated fields and when I entered numbers with space as thousand separator, it just erases the zeros in the subtotal (my subtotal is the addition of three numbers that use thousand separator).

Is there a way to correct this problem ?

Thanks.

[Nesa Nurani · Accepted solution]

You can use custom format to format number as space as separator for a thousand.

[Anthony31413260hlxw]

Thank you. It worked.