Create a new Expression or Variable

[#1]

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.

[derekjones · Accepted solution]

Hi Vijay

try using len function in an expression e.g.

=if(len(Purchased)>0,'TRUE','FALSE')

Hope this helps

Derek

[#3]

Great thanks. That worked!

I was doing double quotes around True and False and it did not like that.