I am creating a report in which I need to calculate the sum of all jobs. I used a running total and tried putting a formula in my running total for having count(jobnum) > 1 and it did not work. In some cases my report shows multiple lines for the same job (which I need it to do), but I need sum all of the jobs that have different job numbers.

Ex:

Job Num   DocTotal     Color
1        $100        Red
2        $50          Blue
2        $50          Black
3        $100        White

Right now my result is $300. I need my result to be $250.

Can anyone help?

I need to sum the doctotal field.

If there was a distinctsum I would be fine.

not sure if this will work
if distinctcount({job_id(field)})= 1 then sum({doctotal field})
or if there is a group
if distinctcount({job_id(field)})= 1 then sum({doctotal field},groupname)