Good Day, I've got an error in my select query when I use a formula field in the query. I've already read it in the documentation that using formula field as table column in select statements is not allowed. For meanwhile i'm using a work around by using triggers to set the value in a static field so that i can use it in a select query. I hope there will be a way to use formula field in select query as it will save more time in development. I've also included some screen shots of the actual error in select query. screen shot 1: screen shot 2: screen shot 3:
I think error message is clear enough: column you're trying to use does not exist. Please do not type column names on your own but copy available column names fro helper UI box.
Some fields (including formula) do not have corresponding columns and cannot be used in queries.