Extracting Negatives

Problem

won't extract negative numbers in project list from MacNail construction estimating software report of construction line items.

Diagnosis

They are doing an extract from a MacNail estimate, and it doesn't pick up items with a negative quantity.

Solution

go to cell F110 in the Estimating Manager (Mac). Formula is:
=FORMULA(IF(include.titles,"=sum(r["&F106&"]c[1]:r["&F106&"]c["&IF(version<3,4,3)&"])>0",">0"),"r[1]c4")
add < signs so it's=FORMULA(IF(include.titles,"=sum(r["&F106&"]c[1]:r["&F106&"]c["&IF(version<3,4,3)&"])<>0","<>0"),"r[1]c4")

Comments

Entered 1/11/99 by Dennis. Updated 11/17/2010.