In query i want to put following condition,
If 'Delivery Status'="X" Then
Delivery Status : Characteristics (Values:'X')
PO Balance : Calculated Key Figure ('PO Qty' -'Recd Qty')
means if the delivery status charecteristics value is "X" then put zero otherwise print PO Balance calculated key figure.
how can i do this?
Muralidhar C replied
HI Try this out:
1.Create two RKFs one for 'PO Qty x' and one for 'Recd Qty x'.
both should be restricted by 'Delivery Status'..'X'.
now Create a formula 'Po balance x' = 'PO Qty x'-'Recd Qty x'.
So this Fomula displays PO balance for delivery status 'x'.
U can hide two rkfs now.
2.now create one more formula 'PO balance' = ('PO Qty' -'Recd Qty')
<i>now in columns u will be having 'PO Qty','Recd Qty','Po balance x' ,and 'PO balance'.(and ofcourse two hidden rkfs)</i>
3.Now create one formula for required PO balance say 'PO balance-Req' = ( 'PO Balance x' <> 0 ) * 0 + ( 'PO Balance x' == 0 ) * NODIM ( 'PO Balance' ).
logic:'PO balance X' column will display some value whenever status is 'X' (becoz we restricted KFs with status X and difference of RKFs is 'PO balance x')
and 'PO Balance' will display values Regardless of status.
with that logic,when ever you have some value for 'PO Balance X' column, result would be 'PO Balance' otherwise 0.
Let's take an example: assume we have some value(including 0) for 'PO Balance X' = 10.
as per logic : 10 + 010 = 0( 'Po Balance-Req')
Assume we dont any value for 'PO Balance X'.
As per logic: 00 + 1 ('PO Balance') = 'PO Balance'.
P.S:Even if u have 0 for 'PO Balance X',formula will return 0.
Now you can hide 'PO Balnace X' and 'PO balance' also...
hope You understnad it.Let me know whether it works.if not we have alternative for this.
Please don't forget assign points if it helps.
Message was edited by: Murali