{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}
AND {HRO.STATUS} = "C"
if {HRO.STATUS} = "C" AND {HRO.PAY_DATE} in DATE (2009, 11, 15) to Date (2009, 11, 21) then
{HRO.TAX_PARTS}+{HRO.NTX_PARTS}+{HRO.TAX_LABOR}+{HRO.NTX_LABOR}+{HRO.TAX_SUBLET}+{HRO.NTX_SUBLET}+{HRO.SUPPLIES}+{HRO.ST}-{HRO.DISP}-{HRO.DISL}-{HRO.DISS}
else 0
They are attached below.. the formula above and below reference two different tables.
Open in new window