You need to sign in to do that
Don't have an account?
Vinitha Subramanya
IF formula receiving syntax error missing ')' in summary report formula
Hi All,
I am trying to build a summary report formula for our funding report but receive the Syntax Error. Missing ")". appreciate your advise on this.
I am trying to build a summary report formula for our funding report but receive the Syntax Error. Missing ")". appreciate your advise on this.
I would remove the UNIQUE keyword and test for RecordType.Id = 'that string'
regards
Andrew
All Answers
Please use the below formula syntax:
Let me know if you still face any issue.
Thanks,
Abhishek Bansal.
this is what I get now.
Incorrect parameter type for operator '='. Expected Number, received Text
can you please try to remove the "" from record type id as well.
I am not sure how this UNIQUE function work, please check on google how to pass record id in these type of functions.
Once that is corrected your formula will work fine.
Thanks.
I would remove the UNIQUE keyword and test for RecordType.Id = 'that string'
regards
Andrew
Please use below code:-
If this solution is usefull for you, Please mark as a Best Answer to help others.
Regards
Mukesh
Thanks, Andrew! Removing the UNIQUE keyword from the record type solved it.