Skip to Content
0
Former Member
Mar 23, 2006 at 08:23 PM

Formula Help needed

17 Views


material Produced qty Consumed qty %consumption

-


A11 4 2 2/15

B11 5 3 3/15

C11 6 4 4/15

-


Result 15

-


Hi Experts,

We have a report like this as per our business rule

%consumption = value of individual row in consumed qty/result of produced qty column.

result of produced qty column = SUMCT(produced qty )

We use SUMCT to get the result of produced qty and is used in the formula. The issue here is when we drill down and swap with different characteristics it is not bringing right results.

Any better solution to fix this issue is appreciated.

Thanks,

Varun.