I have a situation where if a given condition is met I want to take action, but if it is not met, I don't want to do anything. The line item is of type number and setting it to 0 is not a viable option for the ELSE side. So how can I code "do nothing"?
In your example, the Jun value should be 230 but the LEAD function overwrite that value with the Aug Sales value. I actually got it to work by changing the logic of the line item I'm posting so that if the condition is not met, that line item becomes 0 and then the POST function gives the proper numbers.
Thank you all for your suggestions, much appreciated.