OFFSET Value

hyudolee
Occasional Contributor

OFFSET Value

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/11/21/31/41/5
Amount A 100200300 
OFFSET 102 
Amount B100300200  
Result 00000

 

How can I solve this problem?

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

4 REPLIES 4
AntonMineev
Certified Master Anaplanner

Re: OFFSET Value

Hi @hyudolee!

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

Misbah
Moderator

Re: OFFSET Value

@hyudolee 

 

Try this

 

POST(Amount, -Offset).

 

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

 

Hope it helps

Misbah

ChrisHeathcote
Community Boss

Re: OFFSET Value

@hyudolee 

Use POST Function Link as described by @Misbah 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
hyudolee
Occasional Contributor

Re: OFFSET Value

Hi, Anton mineeve, Misbah, Chris Heathcote!

I understand I should use POST Funciton!

I will try it.

 

Thanks!!