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?
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
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.
It was a local field but this one is from a related record:
Of course, I am only sticking in the single number field.
Now it works, not sure what I made wrong in the first time.