Compare last 6 months columns data

Question

Hi, I have 12 months of data spread across columns and need to compare data in last 6 months and update the Comment column based on two conditions. 1) Update comment as Adjusted if value goes down in any of the last 6 months. 2) Update comment as Not adjusted if value is remains same or increases in last 6 months.

Note :12 months input is dynamic represents last 12 months from current month

Appreciate for your help on this.

Account202101202102202103202104202105202106202107202108202109202110202111202112CommentA1033010330103301033010330103301033034708347834794209420AdjustedB148514851485148514851485148514851485176823602360Not Adjusted

atcodedog05 · Accepted Answer

Hi @JJ523

Here is how you can do it.

Workflow:

Hope this helps : )

RolandSchubert · Accepted Answer

Hi @JJ523 ,

what about creating a formula from the field names and handing over this formula to a macro?

I  get the field names using a Field Info tool, select the numeric fields only, keep the last 6, use a Summarize tool to build a formula and a macro for execution.

What do you think, could it be an approach?

Best,

Roland