Skip to Content
0

year table update issue

Jan 03, 2017 at 06:11 AM

35

avatar image

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

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

1 Answer

AMIT KUMAR
Jan 03, 2017 at 10:36 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded