Skip to Content
0
Former Member
Jun 09, 2009 at 08:11 AM

Calculate number of days for the months

30 Views

Dear friends,

We are using BI7.00. For one of our reports, we use 0calmonth in the selection screen with variable so that the from and to months can be entered and the report output can be obtained. In this report i have a requirement which is as follows.

I should create a key figure which will calculate the number of days from the user entered value of from and to month in the selection screen. i.e.,

1)if the selection screen value is entered as 01.2006 then sytem should calculate as 31 days

2)if the selection screen value is entered as 01.2006 to 02.2006 then system should calculate the days as 31+29= 60 and so on....

I tried the following

1) Created a formula variable as replacement path with 0calmonth but this is not functioning properly.

I searched in the forum but couldn't get exact information of the steps of achieving my requirement.

I want to achieve this only by using formulas and no coding of user exit

Is this possible -?

Experts help required.

Regards,

M.M