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

# 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

• ###### Re: Yet another Set Analysis question- no aggregation

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.

• ###### Re: Yet another Set Analysis question- no aggregation

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