This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

how do i write a case statement in a search for sales rep = 'me'

Tried this but it didnt work

case when {custrecord_sales_projection_customer.custrecord_sales_projection_employee} = '@Current@'  then 1 else 0

can you help me with this

the first statement doesnt work but the second one works

same THEN
different WHEN

it works when i do this tho

case when {user.id} = {custrecord_sales_projection_customer.custrecord_sales_projection_employee.id} then 1 else 0 end