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

Formula Help needed


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.