I have a few calculation fields that are sum(amount) through some dynamic self-relationships. I am trying to get zero to display if there are no records through the relationship. I tried:
If ( (Sum (table::amount)) =/= "" ; Sum (table::amount) ; 0 )
but it did not work. How would I create a field calculation to sum through a relationship and display zero if there are no records through the relationship?