Known Issues with using POST and IF??
@Misbah @JaredDolich @rob_marshall
If you know there is an issue with using POST with IF then please let us know, if you don't please read on.
Context: We would like to move a value from the current period in a line item to another line item x periods ahead under a certain condition.
IF Condition is satisfied
THEN POST(Source, x)
If we don't use the condition, the POST function produces the results as expected (see below)
If we add the IF condition based on the condition line item, POST doesn't perform as expected. It doesn't "move" the Source Value and the formula resolves to 0 in the same period (see below)
As a side note, I tried to use a numeric condition and the results were the same.
Finally, when I hard code TRUE as the condition, the POST function works (see below)
Does anyone have an explanation for this behavior? even if the explanation is this is a bug.