Home What is SAP BW?SAP BW Training Tutorials for Beginners What is SAP ODS?Infocube In SAP BW SAP Create Logical System Error Reading Data of Infoprovider SAP BW Certification Cost In India SAP BW Interview Questions TSV_TNEW_PAGE_ALLOC_FAILED in SAP BW SYSTEM_NO_ROLL Dump in SAP SAP Error Dbsql_Table_Unknown SAP B1 Transaction Types

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

Updated May 18, 2018

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 Chandan Singh Parihar 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.