Error in calculated field

Q&A
, ,
1

Hi!
I’m trying to creat new calculated field, from this existing field “Site_Name(1)”:
image

when I begin to write in the new field query, its offer me the right option:
image
(the third option)

however, once i press the right option and try to save the field, there an error:
image

what am i missing here? can you help?
tnx!

2

Hello @shirakoresh !

In your first screenshot, the characters in parentheses for Site_id and Site_Name look to me like they are lowercase Ls and not 1s. Can you try typing in Site_id(l) and seeing if that comes up as a field at all?

3

it may not like the naming with “()”… Try without.

4

Thank you! it worked