BookmarkSubscribeRSS Feed
harsh1
Calcite | Level 5

Hello everyone,

                         Can anybody tell me how to calculate YTD in SAS VA starting from April month till March as per indian fiscal year.

 

Regards,

Harsh Patel

4 REPLIES 4
SuryaKiran
Meteorite | Level 14

Did you try using the custom code to get your result. Please provide what you have done so far.

Thanks,
Suryakiran
SASKiwi
PROC Star

According to this post the periodic functions in VA can only handle calendar years - an enhancement is planned but is not yet available. The workaround is to add a column to your data tracking financial year prior to loading into VA. If you want help setting this up please advise.

https://communities.sas.com/t5/SAS-Visual-Analytics/Financial-Calendar/m-p/310901#M5791

Madelyn_SAS
SAS Super FREQ

Release 8.2 offers the ability to create a fiscal year. See Cumulative Period in the user's guide:

 

 

 

 

BrunoMueller
SAS Super FREQ

Check the whats new in VA7.4

 

it says:

  • The CumulativePeriod operator for aggregated measures now enables you to customize the starting month for each year (for example, to calculate year-to-date based on the fiscal year for your company).

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 4 replies
  • 2668 views
  • 2 likes
  • 5 in conversation