Skip to Content
0
Former Member
Jan 24, 2011 at 09:16 AM

Furmula displaying incorrect result at Hierarchy Node level

30 Views

Hi Experts,

I have created query which is using simple formula as Amount = Price * Quantity.

The query is using hierarchy on Material.

When I drill down to the lowesr level (leaf node) the formula is showing correct result.

But at all the node levels its displaying incorrect result.

Ex.

Mataterial 1 Rate = 4 Quantity = 10

Maaterial 2 Rate = 3 Quantity = 10

In hierarchy both the se materials are under same node (Parent node) say Node 1

The query output is

Material Amount

-


Node 1 140 (7 * 20)

Material 1 40 (4 * 10)

Material 2 30 (3 * 10)

It should be

Material Amount

-


Node 1 70

Material 1 40

Material 2 30

Please suggest how can this be achieved.

Regards

SSS