Date Selection and Different Multiplying Condition

SH_94

Hi Community,

I would like to perform the following analysis with the multiples of data format as below

A. I want to write a formula in Alteryx to identify latest beginning date whereby it will depend on the following conditions:

     - If the movement date is empty , the latest beginning date will be the initial date.

     - If there is date under the movement date column , it will be the latest beginning date.

B. Once i got the latest beginning date, i would need to obtain the final date whereby it will be equal to latest beginning date + number of months.

C. I would like to calculate the number of years which it will be equal to the number of months divided by 12.

D.Once i got the number of years, i want to calculate the Depreciation rate with the following conditions:

   - If the method is SL, the formula will be 1 divided by number of years

   - If the method is DD, the formula will be 2 divided by number of years

E. Lastly, i want to calculate the final amount which it is equal to amount multiply against the depreciation rate.

From the step above, i not too sure how to write the formula for step A,B,D and E. Appreciate if someone can guide me or share the workflow on how to build the complete workflow based on the above conditions

Kindly refer to the screenshot below for your reference.

AngelosPachis

Hi @SH_94 ,

Thank you for this. I have created a workflow with all the expressions you were looking for. I've broken it down to a single expression per formula tool, so it's easy for you to track where changes happen.

You can of course do it in a single formula tool, if you need to reduce the amount of tools used.

Hope that helps,

Angelos

example.yxmd