SAS VA Cumulative Period

[ashishj816]

Hi All,

I am trying to create Cumulative Period based on calculated item.

i Want current year amount and previous years amount.

CumulativePeriod(_Sum_, 'Revenue'n, _ApplyAllFilters_, 'Year'n, _ByYear_, _Inferred_, 0, _Full_, '31Dec2019'd) 

Revenue is calculated item, Years is date format Year contains 2018,2019.

it is giving me unknown error in the  message.

help me in this 

[VDD]

You have not supplies data nor sample code to assist us in help you.

How to create a data-step version of your data
https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

How to Add attachments
https://communities.sas.com/t5/Community-Memo/Adding-attachments-to-your-communities-posts/ba-p/4647...

[Sam_SAS]

Hello,

Does the error occur when you are editing the calculated item, or when a report object containing the calculated item is displayed?

Thanks,

Sam