We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Using Period to Date Calculations

by SAS Employee anna_holland on ‎02-04-2014 02:32 PM - edited on ‎11-25-2015 09:11 AM by Community Manager (1,404 Views)

Happy Tuesday Everyone,

 

In Visual Analytics 6.3, we released some very powerful and intuitive functionality around period to date calculations. I have attached a document written by our SAS VA product management team. This article covers the conceptual approaches of creating solid base understanding of the functionality.  With powerful ways of solving business problems, there can be a learning curve. We tried to flatten that learning curve for you in the document. If you have some good use cases for this type of functionality, please chime in. We would love to hear some of the ideas people have around using functions like these to solve business problems.  If you have used Visual Analytics 6.3, please let us know how you have used period to date calculations already as well.

 

Regards,

 

-Anna-Marie

Comments
by Occasional Contributor AndiWindisch
on ‎02-04-2014 03:46 PM

Hey Anna-Marie,

thanks a lot for sharing the paper! I have tried just a few possibilities of the "Aggregate Measures", it looks very helpful.

Best regards,

Andreas

by Trusted Advisor
on ‎02-05-2014 01:19 AM

Hi Anna-Marie,

Thank you for sharing this document. It is great to see these new period to date calculations in SAS Visual Analytics 6.3.

I was wondering whether there are plans or if you had any advice on how one can do Financial Year to Date type derivations or even Retail Calendar Intervals within the VA interface as you can create in Base SAS with the INTNX function using Shifted, Custom or Retail Calendar intervals - http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p0g056g35ez8son1sfav...

I am aware of a few sites that need to provide financial and retail calendar reporting within VA and I see that this would be need to be done as part of the data preparation.

Perhaps in a future release there could be a configurable financial year setting as part of the VA installation with the ability to do other types of date based intervals?

Kind Regards,

Michelle

by SAS Employee anna_holland
on ‎02-05-2014 09:33 AM

Andreas, we are happy to share the paper and hope you find it valuable! Michelle, you present some great ideas for more detailed examples. I will present the ideas to my team and will get back with you!

Regards,

Anna-Marie

by Trusted Advisor
on ‎02-05-2014 03:32 PM

Thanks . I look forward to see what the team suggest.

Cheers,

Michelle

by Occasional Contributor DamianMcLoughlin
on ‎03-05-2014 04:32 PM

HI - was wondering if anyone has a way of using the period calculations with a financial year field - or can think of a workaround? on site at an org who use financal years - so need to be able to calculate differences across these as opposed to years.

by SAS Employee anna_holland
on ‎03-06-2014 09:39 AM

Hi DamianMcLoughlin, you bring up a great point about using the period calculations with a financial year field. Would you mind posting your question as a new thread? I think current and future community members would benefit from this example.

Thanks,

Anna-Marie

by Contributor rmalcata
on ‎03-05-2017 07:41 PM

hi,
Do you have any progress in financial calculations?

 

I have gone around and have a formula for the calculations by using cumulative period up to a date. However, I would like to have this date as a variable and not as an input.

Is there a way to transform a variable date, category into date?! look at the error message

The formula works if I change the 2nd yellow as '20Jun2016'd, but ideally, if I create some variables as date, I would like to include them in the formula. Is there a way to do this?!

 

cumulative year calculations.PNG

 

 

Your turn
Sign In!

Want to write an article? Sign in with your profile.