Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having trouble with my formula. I want the expression to only count the names that equal eachother in two fields.
Here is what I have:
=Count(if([Queried Provider]=[Responding Provider])
If anyone could give me advice it would be appreciated!
Thanks,
Erin
May be this
-Count([Queried Provider]=[Responding Provider])
or this
Sum(If([Queried Provider]=[Responding Provider], 1, 0)
May be this
-Count([Queried Provider]=[Responding Provider])
or this
Sum(If([Queried Provider]=[Responding Provider], 1, 0)
I think you're missing a right parenthesis and also need to complete the if logic, such as if [Queried Provider]=[Responding Provider] then n else x or
Count(if([Queried Provider]=[Responding Provider],1))
Thank you! The second expression worked!