Number of working days calculation on BEX Query

[KALAISELVI]

Hi,

In bex query,i have filter on id-startday characteriscs -interval selection option which has from and to values user input.

i want to calculate number of working days based on factory calender and i have created exit in cmod using Function module 'DATE_CONVERT_TO_FACTORYDATE'.I have created formula variable with customer exit and written code and assigned to this formula variable .Experts please guide how to pass user input variable as import parameter to this fm in cmod.If it is characterics variable w ecan use i-step = 2 but for formula how to pass this input data variables as input

[falkste]

You don't need to calculate the working days within your query by hand. Just use the attribute 0NUMWDAY of Info Object 0CALMONTH. With a Replacement Path Formula Variable in your Query you can then get this value for further calculations available for the key figures.