Joined: 29 Oct 2014
Online Status: Offline
Posts: 1
Topic: Identifying last 'order Number' Posted: 18 Nov 2016 at 12:47am
I have a table with (amongst other data) a field of dated order numbers for each of several sales team members. Before we load this data into the finance system each day we need to check that the first order number of the day for each member of the sales team follows on from his last order number of the previous day (i.e. last order number +1) or from the last day he worked which may be a number of days/weeks ago.
How do I, for example on the 18/11/16, check that the first order number on 18/11/16 for each salesperson = the last order number +1 for that salesperson when I don't know how many days ago that 'last order' was?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 18 Nov 2016 at 5:28am
The only thing I can think of is to group by sale member, sort by order number then have a formula in the group footer that would look something like this.
if {ordernumber} - previous({ordernumber}) = 1 then 'good' else 'not so good'
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
