Two time periods in one query
I have one query which select material movements within a time period. Therefore I have the characteristic 0CALDAY and variable 0I_DAYS.
Is it possible to enter two time periods at once in order to analyse material movements for two time periods and buils a difference between both.
I could do this with two queries in a workbook, but I want to do this in one single query.
Any ideas would be great.
Stefan from Munich/Germany
Yes, use a structure.
Have 0CALDAY in both selection in a structure, one with a variable that prompts for the first time period and the second with a different variable that prompts for the second time period.
If you put two ranges on the characteristic outside of a variable you wont be able to compare the two values as they will all run into each other.