Forum Discussion
Nissa23
Helper I
Helper ICalculate sum() according to a date range
Hello, Here is a sample of my table : ID Name Start_date End_date Current value 1 A 1999-01-01 2999-01-01 1 15 2 B 1999-01-01 2023-03-22 0 10 3 B 2023-03-22 29...
Hi Nissa23 ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Nissa23 ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
