Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | Year | EXP | New Exp |
123 | 2022 | $ 100,000 | $ 100,000 |
123 | 2023 | $ 0 | $ 100,000 |
123 | 2024 | $ 0 | $ 100,000 |
123 | 2025 | $ 0 | $ 100,000 |
456 | 2015 | $ 200,000 | $ 200,000 |
456 | 2016 | $ 0 | $ 200,000 |
456 | 2017 | $ 0 | $ 200,000 |
456 | 2018 | $ 0 | $ 200,000 |
456 | 2019 | $ 0 | $ 200,000 |
456 | 2020 | $ 0 | $ 200,000 |
Hi - I have the above data...want to create new column 'New Exp' as above, where same Expense amount is diaplyed for all years per lease.How can I do that ?
Thank you much.
Resolved this usimg below expression
=Aggr(Sum(TOTAL <[D]> [Exp]), [ID], Year)
Resolved this usimg below expression
=Aggr(Sum(TOTAL <[D]> [Exp]), [ID], Year)