Skip to Content
0

previous value ignore input control

Dec 12, 2016 at 04:29 PM

20

avatar image

Hi,

I'm setting up a report that includes budgets, now these budgets can be adapted on a monthly base but they don't have to... so the data looks as follows:

nov-2015 50.000
dec-2015 60.000
feb-2016 75.000
apr 2016 65.000

Now what my data should look like is:

nov-2015 50.000
dec-2015 60.000
jan-2016 60.000
feb-2016 75.000
mar-2016 75.000
apr-2016 65.000

this works fine by using the if null then previous(self) function, but we also want to use a ytd overview where we select only 1 year...

Then the previous(self) isn't "smart" enough to fetch the last known data from the previous year

so jan-2016 stays at 0...

Is there a workaround for this? my explanation probably sounds more complicated than it really is...

thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mahboob Mohammed Dec 12, 2016 at 06:34 PM
0

Hi Glenn,

Do you have a Budget/Planning Date object? If yes, you can use something like the below formula to get the previous months, regardless of having to get Dec last year's data. Let's create 2 additional variables before that. Note: You should have BO 4.1 SP6 or later version for this MonthPeriod parameter to work in RelativeDate function.

v_Previous Month Budget = [Budget Amt] where ([Budget Date] = RelativeDate([Budget Date];-1;MonthPeriod))

v_Monthly Budget =If(Isnull([Budget Amt])) Then [v_Previous Month Budget] Else [Budget Amt]

Let us know if that helps.

Thanks,

Mahboob Mohammed

Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Dec 19, 2016 at 05:30 PM
0

If the Budget/planning objects is not of date type, then try using the below:

[Date]=todate(("01/"+Monthnumberofyear(todate("01-"+[Month-year object];"dd-MM-yyyy"))+"/"+Year(todate("01-"+[Month-year object];"dd-MM-yyyy")));"dd/MM/yyyy")

=timedim([Date];MonthPeriod)

Share
10 |10000 characters needed characters left characters exceeded