Skip to Content

year table update issue

Hi All,

Report have 12 tabs , each tab fetch data for single month eg(2016M1 , 2016M2,.. 2015M12 ) We manually applied filer on each tab . We are using oracle database , every year, year table will be updated Now table is updated to 2017, now i need to change manully month tab .. there is not alternate solution

advance thanks ,

raghunath

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 03, 2017 at 10:36 AM

    Instead of changing manually create individual variables for each tab and apply filters.

    e.g For V current Month=if([your month/Year]=formatdate(RelativeDate(CurrentDate();-1;MonthPeriod));"yyyyMM") then 1 else 0

    Apply filter where V current Month is equal to 1.in above formula you have to make sure your both objects datatype should be same.later you can use similar type of variable for each month.

    Add comment
    10|10000 characters needed characters exceeded