Set Analysis with Previous Month

[#1]

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

[vishsaggi]

Try this?

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

[#3]

That turns the field to 0.

[vishsaggi]

‌can you share a sample to look into please?

[#5]

Do you know how I can share proprietary data?

[vishsaggi]

Follow these instructions please:

Preparing examples for Upload - Reduction and Data Scrambling