How to display an accumulator if it does not exist for an employee?

[NOLA]

I created a report that list employees with a certain accumulator and the amount, but one employee does not have this accumulator and I am trying to list this employee with zero values? Is this possible?

 

[Lari2]

All you need to do is a Derived Field with a SUM(DISTINCT DECODE("ps_al_ytd_accum.accum_nbr",'accumulator number',"ps_al_ytd_accum.accum_amount",0)) Also, be sure that you have Database Grouping On.