I've created a calc field using the aggregate Sum(score) to give me a "total
points scored" for all related records in a self-join. I then created a
checkbox that, if checked, I want the score from that particular record
omitted from the Sum calc (but I want the score preserved so I can't have
the checkbox zero out the score field). Is this possible?
The only way I can think of seems clunky: create scoreForSum calc =
Case(omit = "true","",score)
I would then use Sum(scoreForSum) to obtain "total points scored".
As I said, it seems clunky with the ...