previous value ignore input control

[Former Member]

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

[former_member198519]

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)

[mhmohammed]

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