Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Summary Criteria with "Nested" CASE
I have this as a results and works as intended. It is basically what tier a customer should be in.
CASE WHEN SUM({amount}) > 50000 THEN 'Platinum' WHEN SUM({amount}) > 25000 THEN 'Gold' WHEN SUM({amount}) >= 12500 THEN 'Silver' WHEN SUM({amount}) < 12500 THEN 'Bronze' WHEN SUM({amount}) = 0 THEN 'New Customer' END Also we already have a 'Customer Tier' field and basically what I want to do is use the tier formula to pull only the results that are not correct. I am trying to adapt this for the summary criteria results.
CASE WHEN {customer.custentity_kcd_customer_tier} = CASE WHEN SUM({amount}) > 50000 THEN 'Platinum' WHEN SUM({amount}) > 25000 THEN 'Gold' WHEN SUM({amount}) >= 12500 THEN 'Silver' WHEN SUM({amount}) < 12500 THEN 'Bronze' WHEN SUM({amount}) = 0 THEN 'New Customer' END THEN 'true' ELSE 'false' END 0