- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.