Re: Calculation with COLCOUONT - SOLVED

2010-08-19 Thread Brittain, Mark
List) [mailto:arsl...@arslist.org] On Behalf Of Frank Caruso Sent: Thursday, August 19, 2010 1:18 PM To: arslist@ARSLIST.ORG 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

Re: Calculation with COLCOUONT

2010-08-19 Thread Frank Caruso
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 > > Su

Re: Calculation with COLCOUONT

2010-08-19 Thread Charles Baldi
> > > 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, > > >

Re: Calculation with COLCOUONT

2010-08-19 Thread LJ LongWing
onditional 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 c

Calculation with COLCOUONT

2010-08-19 Thread Brittain, Mark
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 pat