I want to Offset values from dynamic day value.
I hope the "Amount A" is offset to "Amount B like table.
But the result was 0.
How can I solve this problem?
When I use Monthly Offset Value, I could do it.
Make sure that sum A and sum B have overlapping time ranges. These are the conditions for the formula.
In the syntax, Offset has to be negative in your case
Hope it helps
Use POST Function Link as described by @Misbah
Hi, Anton mineeve, Misbah, Chris Heathcote!
I understand I should use POST Funciton!
I will try it.