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