2 Replies Latest reply: Jan 31, 2013 8:09 AM by Jason Newman RSS

    Yet another Set Analysis question- no aggregation

      In a table I tried to use:

       

      =if(ACTUALGENERALSETTLEMENT > 0,

             if(YEAROFSETTLEMENT <> '9999',

             sum(Severity)))

       

      But this did not work (not sure why) so I used the following set analysis and it worked:

       

      =sum({$<[YEAROFSETTLEMENT] -= {"9999"}>*<[.ACTUALGENERALSETTLEMENT] = {">0"}>} [Severity]

       

      I am now trying to create a chart where I would like to show the Claim number if:

       

      =if(ACTUALGENERALSETTLEMENT > 0,

             if(YEAROFSETTLEMENT <> '9999',

             ClaimNo))

       

      The problem I have is that I cannot use the set analysis without an aggregation function and I just want the claim number displayed if it matches my criteria.

       

      Is there a way I can use the set analysis without the need for aggregation?

       

      Regards

       

      Jason