Yet another Set Analysis question- no aggregation

[#1]

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

[Gysbert_Wassenaar]

Is this a calculation dimension you're trying to construct? Then you can either use your if statement or set expression with an aggregation. A set analysis expression returns only one value. If you need a list of values then you need to use an aggregation.

[#3]

No it is for an Expression.

I have tried using my If statement and it does not exlude a claim where the ACTUALGENERALSETTLEMENT = 0. Therefore it does not work.

As a similar if statement did not work for the table, I assumed this if statement did not work for the same reason when used in the chart.

The chart is a Grid Chart:

Dimension(2) - Expected Settled and Settled

Expression - as above

Regards

Jason