I really need helps with this one, I'm editing one of the existing report because we are implementing new system in our company.
the problem is that my boss wants me to combine the two table and make it looks the way she wants it.

The first table

Job   Description Cust      mat labor overhead sub
1234   New Job       ABC   $1500 $300   $200
3456   New Job       DCF    2000 400    300
       
       Outside             (200)                 200
       Freight             (300)                 300
       Our Freight               (25)    (50)    75

The first part comes from the Job Pervasive table which i have no problem created it.

but the second part is what im stuck with for few days now. here the way they want it.

OUTSIDE: IF (TABLE_LMO) = 'O' AND (TABLE_TRAN) = 50 AND (TBALE_DESC) <> THEN (TABLE_LABOR)

FREIGHT: IF (TABLE_LMO) = 'O' AND (TABLE_TRAN) = 50 AND (TABLE_DESC) = 'FREGIHT OUTSOURCE' THEN (TABLE_LABOR)

OUR FREIGHT: IF (TABLE_LMO) = 'O' AND (TABLE_MACHINE) = 'FRHT' THEN (TABLE_LABOR) + (TABLE_OVERHEAD)

- the formula didn't work when I use the second pervasive table in the report. it works if I created all of the three formulas in each diff reports.Any idea?

- How can I make the number in the formula appear in the report as negative and positive (Sub column) and use it in the reports.


Any help would be amazing!!!!!!!

I just got this job and I have to learn programming and CR.

Im in need of help :)