2 Replies Latest reply on Mar 6, 2009 9:39 AM by synergy46

    calculated field in Grand Total Summary



      calculated field in Grand Total Summary


      I have a sub-summary report the breaks on 2 parts.


      The first part is all positive values


      The second part is all negative values.


      Each record has a field called COUNT that holds a value of -1 or +1


      I have a calculated field called GrandTotalText that looks at sum(count) and if that total is negative, GrandTotalText says "Total Loss".... same for gain.  See below.


      Case(Sum(count)=0;"No Gain or Loss:";
      Sum(count)>0;"Total Gain:";
      Sum(count)<0; "Total Loss:")


      My problem is that no matter what sum(count) is, GrandTotalText ALWAYS says "Total Loss:"


      Got any ideas?