Skip to Content

How to get values for last two monthend dates and current week dates for a selected business date?

Hi Guys,

Good morning

My client has a requirement, If he selects a business date in Calendar(input control), then it should show Last two monthend dates and Current Week dates with amounts. I have tried following formulas:

  1. Previous Month=RelativeDate([Business Date];-DayNumberOfMonth([Business Date]))
  2. Before Previous Month=RelativeDate([Previous Month];-DayNumberOfMonth([Previous Month]))
  3. Yesterday=RelativeDate([Business Date];-1)
  4. Daybefore Yesterday==RelativeDate([Business Date];-2)
  5. Amount for Before Previous Month

    =[Amount] Where ([Business Date]=[Before Previous Month]) (simliar formulas for all dates)

Table is not showing any values(output.png)

I am using Business Objects 4.0 sp04 version

Please suggest any solution for this

Thanks in Advance



requirement.png (149.4 kB)
output.png (61.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Dear Mahesh , exactly same issue , can you eloborate how did you solve. I am trying to show yesterday's value and today's value and the difference. but yesterday value is not appearing. I am also taking the report date from the reportfilter.

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 27, 2017 at 06:40 PM


    Capture Input control value user selection value an apply in the formula.

    =Reportfilter([Business Date])

    Use the above formula for your calculations.



    Add comment
    10|10000 characters needed characters exceeded