Previous function

jamelmessaoud — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

When using the previous function can you by any chance specify a column number?

I have some data like this

I am trying to write an if statement which is something like:

IF(delivery_region = postcode and Previous(delivery = 'Start') and the delivery column = 'Yes' on the sort order 1 column),Previous(postcode)

So basically I am trying to extract NP20 from my data but only when the first column is a delivery. If delivery was "No" I would not want it.

Hope this makes sense?

Thanks

Re: Previous function

YoussefBelloum — Tue, 06 Mar 2018 15:28:47 GMT

Hi,

I don't really understand what you're trying to do but Previous() is a script function.

look at above() and below() instead

shiveshsingh — Tue, 06 Mar 2018 15:40:03 GMT

Can you a bit more clear about the requirement?

jamelmessaoud — Tue, 06 Mar 2018 15:47:27 GMT

This is basically off the back of this topic which i raised here - Delivery/Collection fields

This was answered perfectly but I would like to take it a step further now by trying to create an if statement as mentioned in my original post.

Thanks

jamelmessaoud — Tue, 06 Mar 2018 17:04:09 GMT

I've figured out a way around this now, so this thread can be closed/deleted.

Thanks