MULTIPLE SELECTION ON PROMPT PAGE CAUSES COLUMN TO MISCALCULATE.....

[DiGzâ„¢747]

Hi Guys,

I have a very tricky issue with one of my cognos reports.  The report is calculating properly if run with a single Prod/Dept ID combination (70110/9709). But when I run it using multiple Product/Dept ID combination (70104/9709 and 70110/9709), the calculation on the 70110/9709 is incorrect.  The weird thing here is that, when I run it using either 70104/9709 or 70110/9709 the values are correct.

I have attached here some screenshots for you guys to have a clearer view of the picture....
Before I forgot, thanks to those who responded to my previous issues before. You're suggestions has contributed alot in resolving them....

Hoping for your prompt response,
DiGzâ,,¢747