Set Analysis not working as it should

[Ravi_Nagmal]

Hi All,

I am working on one logic as mentioned below where I am trying to get sum of "USD total fees" of last fiscal year as a when user select current fiscal year in filter on my report  also I have used Set analysis so that Client_ID and Client_Type filter should not effect this logic, but apparently I am getting wrong numbers with this logic.

Please help it is very urgent !!!

sum( {1<Client_Id=P(Client_Id),Client_Type=P(Client_Type)>} if(
quote_confirmation_datetime>= addmonths(Min(total Year_month_new),-12) and
quote_confirmation_datetime<= addmonths(max(total Year_month_new),-12) and match( assignment_current_state,'Assignment') and match(Identifier,'Base_Table')
, [USD Total Fees]))

[Anil_Babu_Samineni]

Instead, i can try something like this

Sum({<Client_ID=, Client_Type=, assignment_current_state={'Assignment'}, Identifier={'Base_Table'}, Year_month_new={">=AddMonths(Max(Year_month_new), -12)<=Max(Year_month_new)"}>} "USD total fees")