Hi Statalists,
I have a panel data of 3200 firms for time span from 2004 to 2018 which contains the multiple financial variables. I want to calculate the change in Accounts Receivables (A/R), but when i calculated the change through formula " Current year value of A/R - Previous year value of A/R" of 2004 of 2nd firms then formula take the value of 2018 of 1st firms as previous year value. So, i face difficulty to calculate change of first year of every firm because they take the last year value of different (previous) company as Previous year value of A/R.
Please suggest the command or formula to solve this issue??????