Skip to Content
0
Former Member
Oct 18, 2011 at 07:00 AM

wrong overall result population in the query output

140 Views

Hi All,

I have few issues with my query..

we have a query which gives report about the brand name, brand element, brand group, netsales, cumulative sales and royality percentage.

1. the over all result for the Royality percentage is not getting calulated properly... i have compared the result setting of the other fields which get proper overall result. i dint find any difference even then i face this issue

2. The royality percentage is a% of netsales.. but here is issue is when i drill down thro Brand element i am getting proper amount i.e. a% of current sales but when i remove drill down am getting wrong value... and this happens only for one brand not for others...i dont understand why is this happening..

3. let us consider we have 4 brands. for 2 brands my royality percentage is getting calculted properly but for 2 brands it is showing wrong value.

can anyone help me out in this issue...

i dint get even a single clue regarding this... need your expert help