I am using SAS Viya 4.0 2022 LTS version.
I am facing difficulty in calculating the YTD Growth based on fiscal Year.
Fiscal Year should start from 1st April.
Case 1 : If an user wants to check YTD growth value for 10th August 2022 then the calculation should be done taking 1st April 2022.
Case 2 : If an user wants to check YTD growth value for 23rd March 2022 then the calculation should be done taking 1st April 2021 as the starting period.
Could you please tell me the exact values I need to put in the calculated field or the steps I need to follow to achieve the same.
I have to calculate YTD Growth based on fiscal year in SAS Visual Analytics, with April as the staring period and March as the end.
Could you please let me know how it can be done on some measure 'X' and date field 'Y'.
(The above images are from the New Calculation > Year To Date Growth)
What should be the inner and outer interval in the above attached images(kindly ignore the values that appear in the images) for fiscal year with starting period as April and end period as March?
You are on the right track! If you edit the expression that is generated from the YTD Growth quick calculation, I think you should get what you need.
The second-to-last parameter specifies which month of the year is the start of the year. So if you change that 1 to a 4, in each instance of the CumulativePeriod () operator, that should change the calculation to use April as the year start.
Let us know if that yields the result you wanted.
I have been experimenting with this, and I think what you want might not actually be possible using the VA expression editor.
The "Year to Date Growth" calculation is actually to compare the Year-over-year growth of the YTD sum. It does not compare to the value of the first month in the current fiscal year.
The following will give you the YTD value based on April as the fiscal year start:
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.