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.
Thanks
Please don't forget assign points if it helps.
Message was edited by: Murali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.