Help with If statement
Summary: Help with If statement
Content (required): Hello, I'm trying to update the column of a report with this logic - If the count of the answer views is great than 1, print the count, else print zero. Below is the sql i am using. It gives me an error that says "Expressions for comparison operators must be same type." Any help is appreciated. Thanks!
if(count(answers.a_id) >'0', count(answers.a_id), '0')
Version (include the version you are using, if applicable): 22D
Code Snippet (add any code snippets that support your topic, if applicable):
if(count(answers.a_id) >'0', count(answers.a_id), '0')
Tagged:
0