Hi All,
Scenario:
In my SAC model, I have the Invoice date and agreed terms of the amount to be paid. So, now based on the terms I want to calculate the payment date.
For example,

In the above chart, I have the invoice date 01-01-2020 and payment terms 30 days, so I am able to calculate the payment date by adding 30 to the invoice date.
But in SAC, I am not able to achieve such functionality as no formula can be applied on date dimensions.
Can you please help me with an idea to achieve this?
Thanks for helping!!