5 Replies Latest reply: Sep 19, 2017 2:37 PM by Vishwarath Nagaraju RSS

    Set Analysis with Previous Month

    Jeb Pittard

      Please help!

       

      I cannot get my set analysis to calculate correctly. The field  PM Fac Rept Bal  is

      sum({$<RecordYYYYMM ={'(=PrevYYYYMM  )'}>} Facility_Reportable_Bal_Amt)

      but the results give the same field in Facility_Reportable_Bal_Amt and PM Fac Rept Bal

       

      As you can see when the record RecordYYYYMM = 201704 the PM Fac Rept Bal

      should be $97,284

      AprilBalance.PNG

      March Balance.PNG