cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
suprodip007
‎08-21-2023
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to calculate year to date growth based on fiscal year

by Calcite | Level 5 in SAS Visual Analytics
‎08-18-2023 09:21 AM
‎08-18-2023 09:21 AM
Hi Sam, There will be issue here if I change the value to 4 as cumulative sum will be calculated and I need the second field to have fixed value. I want second parameter to have fixed value for a particular year and it should be having value of the month of April as the fiscal year starts with April. For Eg, In April 2021, i have ytd_measure1 =10 In October 2021 , i have ytd_measure1= 90 In March 2022 , i have ytd_measure1=190 So YTD Growth in October 2021 = (90-10)/10 *100%=800% YTD Growth in March 2022= (190-10)/10 * 100% =1800% ... View more

Re: How to calculate year to date growth based on fiscal year

by Calcite | Level 5 in SAS Visual Analytics
‎08-18-2023 08:47 AM
‎08-18-2023 08:47 AM
Dear All,   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?    ... View more

Re: How to calculate year to date growth based on fiscal year

by Calcite | Level 5 in SAS Visual Analytics
‎08-18-2023 07:47 AM
‎08-18-2023 07:47 AM
Hi @Ksharp, Thanks for looking forward to my problem. But, I need to do in SAS Visual Analytics and I do not have any exposure to code in SAS Enterprise Guide . FYI, the Case 1 and Case 2 which I mentioned earlier were just examples , I need to do the YTD calculation for a very wide range of duration. Could you please let me know how it is done in SAS VA? ... View more

How to calculate year to date growth based on fiscal year

by Calcite | Level 5 in SAS Visual Analytics
‎08-17-2023 08:50 AM
‎08-17-2023 08:50 AM
Dear All, 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.    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-21-2023 06:40 AM
Quick links