Skip to Content
0
Former Member
Oct 26, 2005 at 07:25 AM

Percentage share

186 Views

Hi all,

I need to calculate the percentage share of each account hierarchy node result in relation to the next level in the hierarchy.

I tried to use %CT function but that is always comparing each node to the topmost node, not to the next level. I guess that's because the topmost node is the only actual result line of the query.

Is there any other function or way to calculate the percentage share?

Thanks,

L