OFFSET Value

hyudolee

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.

	1/1	1/2	1/3	1/4	1/5
Amount A		100	200	300
OFFSET		1	0	2
Amount B	100	300	200
Result	0	0	0	0	0

 

How can I solve this problem?

When I use Monthly Offset Value, I could do it. 

AntonMineev

Hi @hyudolee!

Make sure that sum A and sum B have overlapping time ranges. These are the conditions for the formula.

Misbah

@hyudolee 

 

Try this

 

POST(Amount, -Offset).

 

In the syntax, Offset has to be negative in your case

 

Hope it helps

Misbah

ChrisAHeathcote

@hyudolee 

Use POST Function Link as described by @Misbah 

hyudolee

Hi, Anton mineeve, Misbah, Chris Heathcote!

I understand I should use POST Funciton!

I will try it.

 

Thanks!!