Skip to Content

previous value ignore input control

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 12, 2016 at 06:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 05:30 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded