Conditional portal calculation

[George]

I have a one to many job_header to job_items. I have a field setup in the job_items db called 'category' which is either P, L or O. I have a calc field of:

If(Job Header to items::CATEGORY="L",Sum(Job Header to items::CHARGES)*.6,0) and also If(Job Header to items::CATEGORY="P",Sum(Job Header to items::CHARGES)*.35,0)

I finally add these two calc fields together with: tot_com=L_com+P_com to display the total of the fields in the portal out on the form.

Problem is that the calc is ignoring the condition of testing the value of CATEGORY.

Any help appreciated.

[Geeksharka]

You will need a separate relation set up for each category variable. They are in essence hardwired. Then, create Sum fields in Jobs based on each different relation, and add those up.