Hello, Adding to the original question; if I were to do the A+B; in our case a A-B, our problem would be that it would add the A-B under both A and B. Any workarounds from SAS VA - not from the data if possible- that someone can help? Also, I noticed that if we had a year and dropped the difference from previous parallel period; besides behaving as it did on the calculated A-B as mentioned above, it will also do it for the minimum time period. For example, If I had 3 years of data and filtered to get only the previous 2, it would also add the previous parallel period measure under the earliest year and display a null since the previous year for the earliest year is filtered. Shouldn't just not show? or can we have the parallel period on its own column once?
... View more