How to combine two time period & create a new field for new period

[nevilledhamsiri]

As per the attached data, it has reported Month, Paid Month but I need to create a new field as Tran_Month only when Reported Year & Month equal to Paid Year & Month in the script. After that I need to pick Month provision+ Under over adjustment for that particular created Tran_Month. How this is done.

Thanks In advance

Neville

[breno_morais]

Yeah, everything will work.

[nevilledhamsiri]

Dear Breno,

When clicked on  IT IS why only Monthly provision is shown? Under provision is shown

[breno_morais · Accepted solution]

When you click in IT IS, just show "Reported Year & Month equal to Paid Year & Month".