Col Comparison

[geeksqaud]

Hi ,

I Have a requirement where i need to compare values across columns .

The value for Day 2 is populating from Day 1 "Current" column and like wise 

The value for Day 3 prior is populating from Day 2 "current" columns like wise 

The value for Day 4 is populating from Day 3 "current" columns like wise

	prior	current
day 1		1
2	1	1
3	1	1
4	1	1
5	1	1
6	1	1
7	1	1
8	1	1
9	1

really appreciate your help .

Thanks,

GS

[cmcclellan]

Just use a Multi-Row Formula,  where Prior (possibly a new column being created in the tool) is simply:

[Row-1:current]

[geeksqaud]

Thanks!! 

	curr	prior
day1	1	0
day 2	??	1

How do I populate 1 from prior to curr column ??

[cmcclellan]

Hmmm OK, if you want to populate Day 2 Current from Day 2 Prior then a Formula Tool after the Multi-Row would do that.

[geeksqaud]

Not sure what I am missing. But it is not working :(

[cmcclellan]

Can you provide a XLS of what you're starting with and what you want at the end ?

Or a workflow of what you have so far ?

[geeksqaud]

Attaching my wf . i need my results like below

	cw	pw
day 1	1	0
day 2	1	1
day 3	1

[cmcclellan · Accepted solution]

So something like this ?

[geeksqaud]

Thanks a lot!!!!  i really appreciate this . 

date	CW	PW
day 1	1	0
day 2	1	1
day 3	1	1
day 4	0	1

How do i get the last record  day 4 -cw  as 0 ??

[cmcclellan]

What is the logic behind Day 4 being 0 though ?