6 Replies Latest reply: Aug 16, 2009 8:06 AM by Shumail Hussain RSS

    Syntax Error - Month End Count + Condition

    Shumail Hussain

      Hi,

      I am trying to count the month end numbers of a field AIF where AIF in P and A but it's not working using below code, Can any one please help

       


      count(if(LoadDate_Active=monthend(LoadDate_Active), {$<AIF = {"P"}> + $<AIF = {"A"}>} AIF))


      Regards,
      Shumail Hussain