Hello;
I am creating a calculated field I get the error message as displayed. I am not able to make it out where the mistake is
Please guide me what the reason could be
You shouldn’t need those extra parentheses around the field, but that shouldn’t be your error.
That error is not necessarily IN your calculated field.
Check syntax there will also bring in other errors in the baq.
Go ahead and save and check your conditions, links, subquery lists, etc. Even other calculated fields.
1 Like
What is the name of your calculated field? It cannot be an SQL reserved term.
3 Likes
I would use
IsNull(InvcMisc.MiscAmt,0)
But your formula shouldn’t be the error. Is it your only calculated field? Most likely @Mark_Wonsil is onto it and you have used a reserved word for your calculated field name.
Or a rogue parenthesis in a criteria somewhere.
2 Likes
Yep, that is a bit confusing… When you check for syntax, the error result might come from any part of your design, not necessary from within your current view…
So as a test, you may delete this calculated firld, and run the syntax check again to prove it!
Pierre
1 Like
It’s been 2 days. I think he’s gonna leave us hanging.
1 Like
Yeah, probably a parenthesis in a filter or a join.
Hi Friends
Was not available in office.
as @Doug.C suggested I used isnull(InvcMisc.MiscAmt,0) and it worked for me. This calculated field was used in another calculated field and there was the syntax error. I missed a parenthesis at the end
Thank you so much for the response
1 Like
