[✅ Solution] Referencing a number field in a calculation field

[dirk_s]

If I refer a field of type number, shouldn’t I be able to set the calculation field also as type number? It only gives me the choice of text?

[Jason]

Hi @dirk_s

I think it changes when you add a field it sees as a number:

you can then manually change it back to ‘text’ if you want/need

[dirk_s]

Hi @Jason - was this a number field in the same record? Or in a linked record? Looks like it doesn’t work, if the number field is in a related record.

[Jason]

Hi
It was a local field but this one is from a related record:

Of course, I am only sticking in the single number field.

[dirk_s]

Now it works, not sure what I made wrong in the first time.
Thanks!