Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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