add fields together

[RemJamie]

I am trying to modify the detail advice slips report, I have two income codes that I would to show as one on the report. We have two income codes for Lont Term Disability deductions I need these to show up as one Long Term Disability deduction and have the total for both show up as a single entry. Is there any way to do this in report writer or am I out of luck?

 

[barbola]

You need to create calculated fields. One to hold the amount if it is LTD1 and one to hold the amount if it is LTD2 and the third to add the two together.

LTD1:
Condition: PIncomeCode = "LTD1" (or whatever your code is)
True: PLineTotal
False: 0

LTD2:
Condition: PIncomeCode = "LTD2"
True: PLineTotal
False: 0

LTDTotal: (not a conditional)
LTD1 + LTD2

I didn't try this in my test company, I am just thinking it might work. You also might need separate codes for the units and the rate as well.


Thanks!
Barb E.