Column referencing

Question

Hello,

My data looks like below.

For Aug

ClientAugJulJunTotalUnbilled periodsA626142.333333333B804121.5C1022141.4

For Sep

ClientSepAugJulTotalUnbilled periodsA826162B1024161.6C1021131.3

I'm trying to generate this column Unbilled Periods which is a [Latest Month]/Total.

I used the formulae tool. I did Aug/Total. Then in Sep I've to change the formulae again to Sep/Total. Is there a way I can reduce this manual touchpoint provided only column name & data change but column number(which is 2nd from the left) remains same?

atcodedog05 · Accepted Answer

Hi @aish28warya

Here is how you can do it.

Workflow:

Hope this helps : )

Maskell_Rascal · Accepted Answer

Hi @aish28warya

Here is an alternate way to do this without transposing your data.

I am using a Dynamic Select tool to grab columns by field position, then renaming the latest month to "Unbilled periods", Joining this new field back to the original dataset, and finally updating the field with the Formula tool.

Let me know if this works for you.

Cheers!

Phil