# Query Problem

In query i want to put following condition,

If 'Delivery Status'="X" Then

PO Balance=0

End IF

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? ##### Former Memberreplied

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

0 View this answer in context
View more on this topic or