Calculated Field

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!

Comments

  • How is your total not summing properly? Is it too high? Too low?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**