If statement help please.

[#1]

Sum (if(ActualAccount<>0,
           if([Miscellenious Fee]<>0,
            if(year=, Month=, Date=('>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))')),FeeAmount)))
Am I doing anaything wrong here ?

I want to calculate the sum of FeeAmount if ActualAccount <>0 and if [Miscellenious Fee]<>0  for previous month.

I tried below set analysis expression for previous month calculation and it works fine.

{<Year =, Month=, Date={'>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))'}>}

I want to put this in if statement instead of set analysis.Please help me.

Thanks a lot.

[jerem1234 · Accepted solution]

Try:

Sum ({<Year =, Month=, Date={'>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))'}>}if(ActualAccount<>0 and [Miscellenious Fee]<>0,
            FeeAmount))

Hope this helps!

[#3]

Jerem,Awesome.Thank you.