ParallelPeriod : bad result as soon as there is a missing value

Genesis007 — Fri, 23 Dec 2022 08:20:39 GMT

Hi everybody,

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).

N-1 :

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.

If you have some tips to help me you're welcome

Thanks in advance,

Michel.

topic ParallelPeriod : bad result as soon as there is a missing value in SAS Visual Analytics

ParallelPeriod : bad result as soon as there is a missing value