Case When with Boolean not equal
How can I write a case statement where if something does not equal something - then?
Here is what I have:
CASE
WHEN "2024 Seth Project 1 Item Cat"."Item Cat" != 'INSTALL' THEN ("Sales Order Items"."Quantity" -"Sales Order Items"."Quantity Invoiced") * "Sales Order Items"."Item Price (BCY)"
WHEN "2024 Seth Project 1 Item Cat"."Item Cat" != 'PROG' THEN ("Sales Order Items"."Quantity" -"Sales Order Items"."Quantity Invoiced") * "Sales Order Items"."Item Price (BCY)"
WHEN "2024 Seth Project 1 Item Cat"."Item Cat" != 'SLA' THEN ("Sales Order Items"."Quantity" -"Sales Order Items"."Quantity Invoiced") * "Sales Order Items"."Item Price (BCY)"
WHEN "2024 Seth Project 1 Item Cat"."Item Cat" != 'SHIP' THEN ("Sales Order Items"."Quantity" -"Sales Order Items"."Quantity Invoiced") * "Sales Order Items"."Item Price (BCY)"
Else 0
END as "Product",
This doesn't seem to work at all...
Sticky Posts
How to Add Users to your Organization in ZohoMail?
A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk) In this topic, We will be discussing on how to Add and Invite users only. The Import options are self explanatory. ____________________________________________________________________________________________________________