Hi there - I am trying to add another constraint to a layered case statement but it does not seem to be working.
The below calculated field sums total payment volume correctly - when I then add a filter onto my table for Payment Service = manual it sums the correct amount of manual payments.
Sum(CASE
when `type` = 'installment'
or `type` = 'full'
and `payment_count`=1
then `Invoice Amount (cents)`/ 100
else 0
end)
However, when I try to add it into the case statement itself, it is not summing properly. Is this an issue with my syntax?
Sum(CASE
when `type` = 'installment'
or `type` = 'full'
and `payment_count`=1
and `Payment Service`='manual'
then `Invoice Amount (cents)`/ 100
else 0
end)
Thanks!
