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

    SET ANALYSIS ISSUE

      Max Year works for this Expression

       

      (Sum({<CloseAdmin_Year={$(=Max(Year))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year))}>} NET_INDEMNITY_PAID)+

      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))
      /(
      Count({<CloseAdmin_Year={$(=Max(Year))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year))}>} distinct

      [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({<CloseAdmin_Year={$(=Max(Year)-1)},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year)-1)}>} NET_INDEMNITY_PAID)+

      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({<CloseAdmin_Year={$(=Max(Year)-1)},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year)-1)}>} distinct [Claim No])+

      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