Assistance Needed with Logic for Depreciation Calculation in SAP Analytics Cloud (SAC) Good mornin

[Bernardo_Santos1]

Good morning,

I need help with the logic required to implement the following requirement:

I have a page related to amortizations, where there are two dates: "Acquisition Date" and "Payment Start Date." For example, if the acquisition date is 2024/01, the payment start date would be 2024/02.

The challenge is that, to calculate everything, I need to use a calculated measure:

(Acquisition Value / Useful Life) / 12

This calculated measure value must appear starting in the month of the payment start date and continue in the subsequent months going forward.

Does anyone have suggestions or guidance on the logic needed to achieve this?

[thomas_beck]

Hi,

Not via a calculated measure but here is an example using Advanced Formulas (Data Actions):
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/e88b9a87633c4e19a0dbd...