Column referencing

[aish28warya]

Hello,

My data looks like below.

For Aug

Client	Aug	Jul	Jun	Total	Unbilled periods
A	6	2	6	14	2.333333333
B	8	0	4	12	1.5
C	10	2	2	14	1.4

For Sep

Client	Sep	Aug	Jul	Total	Unbilled periods
A	8	2	6	16	2
B	10	2	4	16	1.6
C	10	2	1	13	1.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 solution]

Hi @aish28warya 

Here is how you can do it.

Workflow:

Hope this helps : )

[Maskell_Rascal · Accepted solution]

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