on 2012 Dec 29 4:50 PM
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.
Request clarification before answering.
Hi,
You may give a try with If..Else statement in Query Designer. The following doc will help you:-----
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
User | Count |
---|---|
81 | |
30 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.