on 03-08-2017 8:19 PM
I am trying to find a way to get the past 6 months as column headings based on the current month.
So for March I want the columns to be Feb, Jan, Dec, Nov, Oct, Sep
Then for April I want to automatically change to Mar, Feb, Dec, Nov, Oct
etc. . .
Hi so we are using XI3? I believe the version is.
I have tried to use the formula above however I am getting an error so I don't think I am able to use the MonthPeriod function.
Any other way to get previous months?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi we use Web Intelligence Rich Client XI3
Doesn't look like we have the functionality to do MonthPeriod as I am getting an error message at the first ; ?
Any tips? I can send a screenshot of the error if it helps?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi so we are using XI3? I believe the version is.
I have tried to use the formula above however I am getting an error so I don't think I am able to use the MonthPeriod function.
Any other way to get previous months?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what is your BO version? if it's BI 4.1 SP06 then you can use monthperiod function to get the last 6 months values.
You need to create 6 formula's to get the last 6 month values.
current month=Month(CurrentDate())
Previous Month=Month(RelativeDate(CurrentDate();-1;MonthPeriod))
similar for other place -2,-3,-4 & -5 in the formula.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.