In bex query designer i can define formula variable with default value. Ex: April discount rate. And i use this rate on calculating. But in May, this rate is changing and i have to change default value. I need a way to enter Monthly rates to use in my query.So when user select May, in the report calculation will used may rate or if the selected month is april , May rate will used in the calculation.
Looks for your help.