Question Re: Creating Calculations between two dates in SAP Analytics Cloud in Technology Q&A

Creating Calculations between two dates in SAP Analytics Cloud

Former Member — Mon, 24 Sep 2018 20:33:25 GMT

Hello,

I am attempting to create calculations between two dates in SAC. SAC only allows one date dimension in the model so I am not able to compare the multiple dates and create calculations between the dates, without making direct modifications to the data set. It seems like we can't create calculations between dates in two seperate linked models either. If anyone knows how to create calculations between two dates in SAC, please share your knowledge.

Thanks.

Re: Creating Calculations between two dates in SAP Analytics Cloud

kohesco — Wed, 26 Sep 2018 13:45:16 GMT

in the latest release they speak of datediff formula

https://www.sapanalytics.cloud/product_updates/release-2018-16/

Re: Creating Calculations between two dates in SAP Analytics Cloud

Former Member — Thu, 27 Sep 2018 15:30:49 GMT

but the datediff function won't work, as you can only import 1 dimension as a date

Re: Creating Calculations between two dates in SAP Analytics Cloud

Former Member — Tue, 11 Dec 2018 22:43:45 GMT

try and look at this post - my reply

https://answers.sap.com/questions/569331/i-want-to-calculate-seniority-using-hire-date-and.html

Re: Creating Calculations between two dates in SAP Analytics Cloud

former_member104313 — Thu, 21 Mar 2019 09:49:26 GMT

Hi, This changed in a recent release. You can now have multiple dates in a model.

I have been using this with SuccessFactors data. The old solution was to split the date into Month/Day/Year and then use the year columns to calculate the date difference.

New issue since you can have multiple dates is how to type a specific date into a formula, no format seems to work. If you figure this out I would be super happy to hear.

Re: Creating Calculations between two dates in SAP Analytics Cloud

Former Member — Thu, 21 Mar 2019 17:54:48 GMT

Hi Jessica

if you have two dates in the data prep phase you can create a calculated column with this formula:

DATEDIFF([Date1],[Date2],"Day")

If it's not a date you can look in my previous answer (there is a hyperlink)

The last part in the DATEDIFF formula can be replaced with "Month" or "Year"

Hopefully this will help a bit

/René

Re: Creating Calculations between two dates in SAP Analytics Cloud

former_member834587 — Fri, 23 Dec 2022 21:17:11 GMT

Good Morning.

I need to subtract two columns from the same KPI, from different years, and have the calculation persist when new years exist.

| 2020 | 2021 | total

-------------|----------|----------|---------

Sales | 235k | 200k | 35k

When the sales for the year 2022 come in, you want the calculation to remain.

How can I do?

Thank you!!

Erick

Re: Creating Calculations between two dates in SAP Analytics Cloud

Subhasmit — Mon, 27 Mar 2023 05:20:26 GMT

Hi,

please go through to the link , I think it will be helpful for you .

https://blogs.sap.com/2020/10/31/date-calculations-in-sap-analytics-cloud-using-custom-date/

Thank You.