Contributor

POST function within IF THEN ELSE construct

In a model I'm working on I need to use the post function.  When I put it by itself in the formula it works fine.  But since I only want to use it when a certain condition is met, I changed the formula to: if NOT lineitem then 0 else post(x,y).  With this syntax, all I get is 0s. Is this a known issue?

 

Thanks

3 REPLIES 3
Community Boss

Re: POST function within IF THEN ELSE construct

Hey - Can you confirm that your boolean line item is getting satisfied?  I have put together an example below and seems to operate as expected.  Is your setup similar? 

 

post_example.png

Thanks.


Jt

Contributor

Re: POST function within IF THEN ELSE construct

the structure I have is similar except that the offset amount comes from a number formatted line item.

 

Thanks for the quick response!

Contributor

Re: POST function within IF THEN ELSE construct

I figured out the issue.  The POST is working but I have think about my condition.  The way I have it now, if the condition is satisfied in week1 but not in week2, the formula in week2 override the posted value with 0.  Thanks for your help.