Question:
Hi All,
We like to write a query based on the PO value. for example, we want to print PO's which high value amount. i.e 1M.
Can some body provide me a clue as to how to implement this using selection criteria
Thanks in advance.
Answer:
Create a condition in the query designer
Answer:
Thank you TFR.
Condition is not really useful in my requirement. I had looked at it and it is not possible to dynamically select the PO amount at the run time.
eg. PO amt
450000001 $50.00
450000002 $100.00
450000003 $1000.00
In the above example, The user would like to select all PO's between $50 - $100. This query will print PO's 45000001, 45000002.
I created a navigational, numeric characteristic in the PO header master table for PO total amount. Created a variable.
This way I was able to get around and provide a solution to the user. I am open for any other suggestions.
Thanks for reading.
Answer:
Your way is indeed also a nice workaround, but just for completeness : with conditions you can also use a variable to determine the amount to which should be used in the evaluation of the condition
(but i think this variable functionality is only available as of 3.X...)
Answer:
Thank you TFR.
Excellent! I was looking for that answer.
We are on 2.1C and this is one more bullet as to why we should upgrade to 3.x.
Thank you for sharing your knowledge.
Answer:
In fact, you can use a variable in a condition in 2.1
Here is the workaround I used in this version :
If I wanted to create a condition on for example Margin, I created a calculated Key Figure equal to Margin Minus Entry Variable (this was authorized in 2.1). In this case, the condition will apply on this calculated KF, referring to 0 instead of variable entry.
example :
Variable entry 20
Margin 30, so Calculated KF equal to 10, so over 0, green
With Variable Entry 40, Margin 30 so Calculated KF equal to -10, under 0, red !!
(OK, I made the example with an exception, but same way of working ).
Anyway, if you need a reason for migration to 3.0 ... forget my post !!
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.