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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
