Hi Guys, I'm trying to show Sales Team Member base...
# suiteanalyticsn
Nilesh Patil
03/10/2021, 6:04 AMHi Guys, I'm trying to show Sales Team Member based on Sales Team Role by using Formula(Text) but it is giving me error: invalid expression in SAVED SEARCH. I tried changing single to double quotes and using == but not working!!!
kindly help me here!!
g
George McMullen
03/10/2021, 6:11 AMPerhaps it’s the
ELSE 0ELSE ''n
Nilesh Patil
03/10/2021, 6:33 AMokay, I thought it will take that 0 as a string , thanks a lot it is working now!
g
George McMullen
03/10/2021, 6:36 AM👍
George McMullen
03/10/2021, 6:36 AMYou could do ‘0’ if you need to display a 0, but you won’t be able to do any math on it.
n
Nilesh Patil
03/10/2021, 6:38 AMI used the 0 before in some searches for Formula(text) and it was working! but it was not in this ! no issues! now it is working thanks to you