Is there a way to get the MIN, MAX, and AVG while ignoring zero values? Ie, getting the minimum non-zero value..
I have a view setup and a select that groups my data by month and year with the min max and avg of some btu values; however I am not interested in the zeroes! I know this ignoring of zero can be done in Excel but it is easier to do the grouping in Rbase.. Here's my view: -------------------- CREATE VIEW minmax5 + (yr_month,btu_inj,btu_with) AS + select ( (ctxt( (iyr(gasday)))) + '/' + (ctxt( (im+ on(gasday)))) ) btu_with btu_inj from daily_data g+ roup by #1 btu_inj btu_with Here's my current select: ------------------------- select #1=10 (avg(btu_inj)) (min(btu_inj))=10 (max(btu_inj))=10 (avg(btu_with))=10 (min(btu_with))=10 (max(btu_with))=10 from + minmax5 group by #1 Thanks! Charley Charles Sikora Coordinator, Gas Storage Manlove Field Peoples Energy Corporation (217)-897-7123
