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 :)
|