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