About dgingras

Would giving the user Read access only instead of Write access allow him/her to do what is needed? With read access, the user wouldn't be able to change the name of the item. ... View more

Thanks Elinas for correcting my error, after I posted it I realized that was wrong but forgot to correct.  I couldn't agree more with you that the documentation is confusing.  To add to the confusion, when another line item is updated and it causes the re-evaluation of all line items, it makes it appear, to me at least, that the POST works differently than it actually does. ... View more

Try this, it should clarify how the POST function works.   IF Boolean THEN POST(Volume, 2, 0) ELSE POST(Volume, -1, 0)   Hope this helps. ... View more

The POST function is not pushing the value from Jan to Mar, it is pulling the value from Jan to Mar. The reason there are no values for Jan and Feb is that the source period is outside the date range. ... View more

Here is the test I did: Isn't this what you are looking for? ... View more

The POST, LAG, OFFSET function all take a value from a prior or future period and put it in the current period. So if you want to put a value in June based on a condition set in April, you need to test that condition in the prior period. I believe this will give you what you want: IF PREVIOUS(PREVIOUS(Boolean)) THEN POST(Volume, 2, 0) ELSE 0 ... View more

If you want to see 14 in May20, try LAG(Volume,2,0).  POST is working correctly. ... View more