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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.