is it possible to sum a value withing a case statement - case when sum({field}) = ... ? the format above doesn't work, so i was curious if there's another method/approach i can use