I've got some problems in SAS VIYA when I use ParallelPeriod function.
As you can see on the example below :
I've a column with annual sales, and I would like to have a column with the annual figure of the previous years, in order to be able to measure the progression of the turnover (column N-1 et N-2).
As you can see, in the cells coloured in green everything is OK. But it's NOK ine the Red cells. I think the problem is linked to the missing values (in the blue coloured cells). As soon as a missing value is present in the line, the parallelperiod result is wrong.
I've tried to replace the missing values with this formula :
But I can't use it, in the ParallelPeriod function because I can't nest two aggregation formulas.