Two time periods in one query

[Private_Member_24235]

Hello all,

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.

Best Regards,

Stefan from Munich/Germany

[Former Member · Accepted solution]

Stefan,

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.

Regards

Gill

[Former Member]

HI,

While entering values in selection screen enter both time periods, and in report output drill down Period in columns under your key figures.

Hope this helps

Thanks

CK