I am preparing a report showing Budget Data (Sales, Cost, PL and GM) as well as part of the labor cost in $.

For the labor cost I had to select several tasks. I used this formula:

if {PJPTDSUM.pjt_entity} = "105231" or {PJPTDSUM.pjt_entity} = "105232" or {PJPTDSUM.pjt_entity} = "105233" or {PJPTDSUM.pjt_entity} = "105239"

then {PJPTDSUM.act_amount}

Else 0

All the amounts per project (line) are right.

However, the totals for the budget data are way off. For some reason, it multiplies the budget amount by the number of tasks used to calculate the labor cost.  I.e. if the labor cost consists of 5 different tasks for a project with a budgeted sales price of $10,000, the amount included in the total for the sales price is 5 x 10,000 = 50,000.

The sum for the labor cost is right.

What am I doing wrong and how can I fix it?

Thanks for your help.

Sabrina