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
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...
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.