Online Tutorials & Training Materials | STechies.com
Register Login

MAX & MIN Calculation at Run Time in a BEx Query?

|| || 1

MAX & MIN Calculation at Run Time in a BEx Query?
Stechies

Hi experts,

I have scenario I need input of date range from the selection screen and according to it need to show MAX & MIN of quantity(Key Figure) field based on certain characteristic. Can anyone suggest any option?

Thanks in Advance.


You can view more tutorials about SAP BW


Comments

  • 04 Feb 2014 5:22 am Best Answer

    You can select 0FISCPER or any other date variable in the BEx variable screen and configure a selection range for the date. As an alternative you can write a customer exit include for selection of a date range. There are MIN and MAX functions in the variable screen on the key figure also. Or you can create a calculated key figure(s) and set it to the MAX and or the MIN.