Skip to Content
0
Former Member
Mar 18, 2009 at 12:45 PM

Calculated Key Figure Problem

48 Views

I am trying to create a new calculated key figure to do the following.

I have the following chars and key figures already in the query.

Example records

PO Number, PO Line Item ,Number of PO Items, New CKF/Formula

1000001, 010, 0

1000001, 020, 1

1000001, 030, 1

(Number of PO items (0PO_ITEMS) is a basic key figure which is set to 0 or 1 based on SAP logic.)

I need to be able to add a new calculated key figure/formula that calculates at the PO level and is equal to 1 if ANY of the POs line items has a "Number of PO Items" value of 1 if not is = zero. The overall result for this new calculated key figure/formula must be a total of this calculation for all POs.

So the result for the new calculated key figure in the example above would be "1" but also it needs to total all other POs for the Overall Result.

Hope that makes sense.

Thanks in advance.

Steve Jones