How to set formula in query for blank value

[Former Member]

Hi Friends,

Need your help / guidance..

I have 1 sales query, in which there are 4 columns

Indent Qty

Indent Value ( B )

Sales Qty

Sales Value ( C )

Sales Price = this is formula based

now the formula is, if sales qty and sales value is blank then it should pickup the value of indent qty and indent value.

I have set the formula, but the problem is bw cannot recognized blank value.

Can you pl let me know how should i resolve this?

I was thinking of writing na end routine, bcz sales qty and sales value is based on value types, so if those value types are there then i shall update 0 in end routine.

Please help.

Thanks

Samir.

[former_member182470]

Hi,

You may give a try with If..Else statement in Query Designer. The following doc will help you:-----

http://scn.sap.com/docs/DOC-11658

[Former Member]

Hi ,

One thing you can do , put condition if sales quantity is greater than or equal to 1 , then sales quantity * sales value else  indent quantity * indent value. Without writing routine it will work,

(  Sales quantity >= 1) * (sales quantity * sales value) +   (NOT (  Sales quantity >= 1)) *(indent quantity * indent value)

Please go though url for if - else  syntax

http://scn.sap.com/thread/3263299

Regards,

Anand Mehrotra,