Question:
Hi,
I have the following scenario.
A customer buys two different materials..One order is closed and another is open. Sales report has two columns, one "Processed" and another "Inprogress".
If the report is run with a material and customer, and input material is processed, then revenue should appear in "Processed"column. If the same customer is run with two materials out of which, one is open, the revenue of both should appear in "In Progress" column.
Is there anyway we can achieve this. I have an indicator at item level that tells the line item is processed or not.
Thanks
KT
Answer:
one restricted key figure to "processed"(A) and one to "in progress"(B);
hide both;
use them to create C and D :
C shows figures if EVERYTHING is processed
D shows figures if AT LEAST one is in progress
C is " ( B = 0 ) * ( B + C ) "
D is " ( B <> 0 ) * ( B + C )"
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.