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 <cba...@ieee.org> 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 <lj.longw...@gmail.com> > 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:arsl...@arslist.org] On Behalf Of Brittain, Mark > > Sent: Thursday, August 19, 2010 10:09 AM > > To: arslist@ARSLIST.ORG > > 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 > > mbritt...@navisite.com > > (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 ARSlist: "Where the Answers Are"_ > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"