Hi Monique,
Unfortunately this doesn't help much but wanted to let you know that this works fine for me in the Adagio Sample Data.
Try out your same process in the sample data and see if you get the problem there. If you don't, have a close look at the sample data setup and see if you can spot any differences that could be causing the problem in your live data.
Pete