Joined: 02 May 2013
Location: United States
Online Status: Offline
Posts: 8
Topic: DisctinctCount Down Posted: 24 Jun 2014 at 11:24am
I have a problem coming up with the formula to count down the distinct records in a list. This is a truck route with the orders listed and some have more than 1 order but I need a record to show the stop.
eg.
SHIPTO ORDERNO STOPCOUNT
ABC Co. Order 101 Stop 3
ABC Co. Order 102 Stop 3
MNO Co. Order 103 Stop 2
XYZ Co. Order 104 Stop 1
XYZ Co. Order 105 Stop 1
DistinctCount(SHIPTO) gives me the 3 but I need the countdown to perform in the list.
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
