Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
FYI.
| Output | ||||||
| Task | Money | cost | Year | Start date | End of date | Cummulative Amount |
| test 1 | 50000 | 821.8356164 | 2021 | 2021-1-1 | 2021-3-31 | 821.8356164 |
| test 1 | 50000 | 830.9671233 | 2021 | 2021-1-1 | 2021-6-30 | 1652.80274 |
| test 1 | 50000 | 840.0986301 | 2021 | 2021-1-1 | 2021-9-30 | 2492.90137 |
| test 1 | 50000 | 840.0986301 | 2021 | 2021-1-1 | 2021-12-31 | 3333 |
| test 1 | 50000 | 2204.232877 | 2022 | 2021-1-1 | 2022-6-30 | 5537.232877 |
| test 1 | 50000 | 2240.767123 | 2022 | 2021-1-1 | 2022-12-31 | 7778 |
| test 1 | 50000 | 1481 | 2023 | 2021-1-1 | 2023-12-31 | 9259 |
| test 1 | 50000 | 741 | 2024 | 2021-1-1 | 2024-12-31 | 10000 |
| test 1 | 50000 | 0 | 2025 | 2021-1-1 | 2025-12-31 | 10000 |
| test 1 | 50000 | 0 | 2026 | 2021-1-1 | 2026-12-31 | 10000 |
| test 1 | 50000 | 0 | 2027 | 2021-1-1 | 2027-12-31 | 10000 |
| test 1 | 50000 | 0 | 2028 | 2021-1-1 | 2028-12-31 | 10000 |
| test 1 | 50000 | 0 | 2029 | 2021-1-1 | 2029-12-31 | 10000 |
| test 2 | 50000 | 1250 | 2021 | 2021-1-1 | 2021-3-31 | 1250 |
| test 2 | 50000 | 416.6666667 | 2021 | 2021-1-1 | 2021-6-30 | 1666.666667 |
| test 2 | 50000 | 416.6666667 | 2021 | 2021-1-1 | 2021-9-30 | 2083.333333 |
| test 2 | 50000 | 416.6666667 | 2021 | 2021-1-1 | 2021-12-31 | 2500 |
| test 2 | 50000 | 1250 | 2022 | 2021-1-1 | 2022-6-30 | 3750 |
| test 2 | 50000 | 1250 | 2022 | 2021-1-1 | 2022-12-31 | 5000 |
| test 2 | 50000 | 2500 | 2023 | 2021-1-1 | 2023-12-31 | 7500 |
| test 2 | 50000 | 2500 | 2024 | 2021-1-1 | 2024-12-31 | 10000 |
| test 2 | 50000 | 0 | 2025 | 2021-1-1 | 2025-12-31 | 10000 |
| test 2 | 50000 | 0 | 2026 | 2021-1-1 | 2026-12-31 | 10000 |
| test 2 | 50000 | 0 | 2027 | 2021-1-1 | 2027-12-31 | 10000 |
| test 2 | 50000 | 0 | 2028 | 2021-1-1 | 2028-12-31 | 10000 |
| test 2 | 50000 | 0 | 2029 | 2021-1-1 | 2029-12-31 | 10000 |
