Percent Change

building reports webintelligence
1

I have a simple report that shows Number of Enrollees by Fiscal Year/Period (ex: 201103). I am building a veritcle bar/line chart. The lines show the number of enrolles by month/year. The line is to show the percent change between periods. I am not sure how to create the variable to show that change. Any help would be appreciated!

cwhittington05 (BOB member since 2010-06-15)

2

You should have a look at the RelativeValue() function. You may not need the NoFilter and where clause, but, heres an example:-

=(NoFilter(([Headcount Operational 14 Month]Where([EmployeeGroupCustomised] = "Perm")))-NoFilter(RelativeValue([Headcount Operational 14 Month];([FutureBaseCalendarDateMMMyyyy]);-1)Where([EmployeeGroupCustomised] = "Perm")))/NoFilter(RelativeValue([Headcount Operational 14 Month];([FutureBaseCalendarDateMMMyyyy]);-1)Where([EmployeeGroupCustomised] = "Perm"))

Mak 1 :uk: (BOB member since 2005-01-06)