I'm using the same data from earlier--number of jobs by state. Data are typically reported in thousands on a monthly series (1990 to 2016). I am looking to compute monthly and annual percentage change on this data.
P1 = first period (month, year)
P2= second period (month, year)
%-change = (P2/P1-1)*100
And as question #2, is there a way to remove the nulls? Thanks!
I've included the data table below Sunny's post. Basically, I'm looking for a means to compute % change for each of the data fields I've created. I'm not sure at this point if it's better for me to hardcode it in the data editor or apply it on the front end.