Hi, I have this Leave Balance list with the initial and increment value for Annual Leave. I have a requirement that Annual Leave increases per month according to their initial value.
For example,
In January,
| Employee Name |
Annual Leave |
| Leo |
1.17 |
| Mike |
1.33 |
In February,
| Employee Name |
Annual Leave |
| Leo |
2.34 |
| Mike |
2.66 |
In March,
| Employee Name |
Annual Leave |
| Leo |
3.51 |
| Mike |
3.99 |
It increases based on the values in January (the initial values).
My flow runs differently than I want. It updates based on the column Annual Leave.
For example, January is the same as the above example.
In February,
| Employee Name |
Annual Leave |
| Leo |
2.34 |
| Mike |
2.66 |
In March,
| Employee Name |
Annual Leave |
| Leo |
4.68 |
| Mike |
5.32 |
It increases based on the current Annual Leave. I don't know how how to create a constant value for the Annual Leave. Can anyone please help me?
Thank you.
