SUM with multiple conditions
I am having trouble with a DOMO Beast mode sum Calculation. Below you will find my existing calculation. I am looking to add the value of all records that have a date to Customer in column A and exclude those records in column B that have a payment date. Essentially I am looking to calculate the value of invoices sent to the Customer and of those who has not submitted payment yet.
Issue: It appears that I am still adding values to my total when payment dates are present.
Can someone please help me to improve my beast mode calculation?
WHEN ` Date To Customer` IS NOT NULL AND `Payment Date` IS NULL THEN (`USD`)