Set Analysis Help

[#1]

I am getting an error with and I am not sure what I am doing wrong. It looks right to me???? I am trying to get a loss ratio and only show the ones that are less than .52. If I take the set analysis part off and just use the sum eqution it returns what I would it expect it to.

Sum

({$<(Sum(Incurred2007) + Sum(Incurred2006) + Sum(Incurred2005) + Sum(Incurred2009)+ Sum(Incurred2008)) /

(Sum(Earned2007) + Sum(Earned2006) + Sum(Earned2005) + Sum(Earned2009) + Sum(Earned2008)) = {"<.52"}>} [Written Premium])

The error I am getting is 'Error in set modifier ad hoc expression'.

[#2 · Accepted solution]

In your "set" expression, I think it's a field that is expected :

sum({$<Field={"value"}> ...

Can't you do your test in a "if" expression ?

Something like

sum(
if((Sum(Incurred2007) + Sum(Incurred2006) + Sum(Incurred2005) + Sum(Incurred2009)+ Sum(Incurred2008)) /
(Sum(Earned2007) + Sum(Earned2006) + Sum(Earned2005) + Sum(Earned2009) + Sum(Earned2008)) <.52,

[Written Premium]))

[#3]

Yep, I will use the If statement. I was so caught up on making the set work, I didnt even think of this. Thanks