Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having a hard time trying to find or figure out how to create a new expression or variable that helps me solve this issue.
I have a field "Purchased" that has no value or count of products purchased like 1,2,4,7,....
I want to create a new variable or expression to basically tell if Purchase is True or False. False if no value and True if >=1
Tried stuff in the script, creating expression in the list box...all to no avail and I'm stuck.
Any help is appreciated.
Hi Vijay
try using len function in an expression e.g.
=if(len(Purchased)>0,'TRUE','FALSE')
Hope this helps
Derek
Hi Vijay
try using len function in an expression e.g.
=if(len(Purchased)>0,'TRUE','FALSE')
Hope this helps
Derek
Great thanks. That worked!
I was doing double quotes around True and False and it did not like that.