Skip to Content
avatar image
Former Member

12 months rolling in webi report

I need to create a webi report with data from (current month - 3) to (current month + 9).

I can access the report level. WEBI only.

So, may I know any idea on the formula to create this.

I tried use months between function but its not working.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 29, 2015 at 08:36 AM

    HI ,

    Check this out,

    It has complete information about Current month, Last month , YTD so on........

    Date Variables in Web Intelligence

    Surely it helps to make your requirement achieved...

    Hope it helps you

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 29, 2015 at 08:42 AM

    Hi,

    Can you clarify it a little bit? You're asking for help in creating the query or in calculating a Sum? Which are your objects?

    Regards,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      MonthNumberOfYear(CurrentDate()) ---> returns this month (eg-Nov)

      MonthNumberOfYear(CurrentDate()) - 3 --> return the last 3 month (eg-Aug)

      I want to retrieve the data between that Aug to Nov.

      RelativeDate(CurrentDate();Number)

      is there anyway to use RelativeDate for Month to Month?

      Todate not working.

      Thanks and regard,

      hikoe

      Capture.PNG (4.6 kB)
  • avatar image
    Former Member
    Oct 29, 2015 at 12:51 PM

    1. Create a expression at report level to Current Month -3

    2. Apply a filter on data block which contains data like Month > Current Month -3

    3. Use RunningSum() function get desired output.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      MonthsBetween() returns number of months between two dates.

      you can use

      RunningSum([Measure]) Where ([yourDateObject] >=RelativeDate()  AND [yourDateObject] <=RelativeDate() )