Hi LJ, Jay, Charles & Frank, Walking the table with one active link guide and two active links does the trick. I should have come up with this on my own. Thanks for knocking loose the cobwebs.
Mark ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Thursday, August 19, 2010 1:18 PM To: [email protected] Subject: Re: Calculation with COLCOUONT ** I would try doing a table walk. Walk each row and perform the calculation against that rows Create Date field, increment your counter and then move to the next row. On Thu, Aug 19, 2010 at 12:31 PM, Charles Baldi <[email protected]<mailto:[email protected]>> wrote: If you used your criteria to set a hidden field on the table to '1', then you can probably use COLSUM to get the result you are looking for. Regards, Chuck Baldi On Thu, Aug 19, 2010 at 12:20 PM, LJ LongWing <[email protected]<mailto:[email protected]>> wrote: > ** > > Mark, > > You aren't going to likely like this...but use an External Qual on your table, > temporarily change that External Qual to what you want, refresh the table, > get a total count, change the external back to 1=1, refresh again. Or, do a > Setfield from the form in question using the qual you want, set the request > ID to a tmp field, then set your counter field with $LASTCOUNT$....or you > could loop through the table, checking to see if the row matches your > criteria and increment a counter if it does...lots of different ways to get > what you want...but no I don't believe you can do a conditional colcount. > > > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]<mailto:[email protected]>] On Behalf Of > Brittain, Mark > Sent: Thursday, August 19, 2010 10:09 AM > To: [email protected]<mailto:[email protected]> > Subject: Calculation with COLCOUONT > > > > ** > > HI All, > > > > Is there way to do a column count based on a calculation? What I am > specifically looking to do is count the row if $TIMESTAMP$ - (60*60*24*14) > > 'Create Date'. The result would be displayed on an integer field on a > display form. Create Date is a field (column) on the table. > > > > ARS 6.3 patch 20 > > SunOS 5.9 > > Oracle 9.2 > > > > Any ideas greatly appreciated. > > > > Mark > > ____________________________________________ > Mark Brittain > Remedy Developer > NaviSite > [email protected]<mailto:[email protected]> > (315) 453-2912 x5835 (Phone) > > (315) 317.2897 (Cell) > > > > > > ________________________________ > > This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that > is privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited. > > _attend WWRUG10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the > Answers Are"_ > > _attend WWRUG10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the > Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
