7 Replies Latest reply: Feb 19, 2014 1:00 PM by Ray HDKJSH

# SET ANALYSIS ISSUE

Max Year works for this Expression

Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max(CloseAdmin_Year)'},Month = {

"<=\$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/(

[Claim No])+

Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max(CloseAdmin_Year)'},Month = {"<=\$(=Max(Month))"}>} DISTINCT [Occurence No]))

But not working for MAx(Year)-1,

Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max((CloseAdmin_Year)-1)'},Month = {

"<=\$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/
(

Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max((CloseAdmin_Year)-1)'},Month = {"<=\$(=Max(Month))"}>} DISTINCT [Occurence No]))

Any Clues

• ###### Re: SET ANALYSIS ISSUE

See underscore.

Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=(Max((CloseAdmin_Year)-1))'},Month = {

"<=\$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/
(

Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=(Max((CloseAdmin_Year)-1))'},Month = {"<=\$(=Max(Month))"}>} DISTINCT [Occurence No]))

Best Regards.

Tonial.

• ###### Re: SET ANALYSIS ISSUE

Doesnt Work, any more ideas pls

• ###### Re: SET ANALYSIS ISSUE

Have you tried      Max(Year -1)

• ###### Re: SET ANALYSIS ISSUE

Yes I did

• ###### Re: SET ANALYSIS ISSUE

If Year is a dimension on your chart, it's not going to work.

• ###### Re: SET ANALYSIS ISSUE

No Dimenion is the Month

• ###### Re: SET ANALYSIS ISSUE

can u try this add '\$(=(Max(Year)-1))'