@txnelson This is great! Thanks. Works like a champ. But, of course... I have a question... I'm not sure why it works.
The IF statement assigns 0 to Row 1, got that. If the row is anything other than one, it leaves the cell blank, right?
The SUM statement then takes the current value of sumx, adds the current Availability value and subtracts the Availability value from row - 8759 and assigns the result back to sumx. I've got that.
But my question is... why does the current value of sumx show up in the cell? There is nothing in the formula (apparent to me) that says... "Show sumx". Does the assignment "sumx = ..." automatically imply in JMP that the result will display in the cell?
Sorry if this is a dumb question. But its understanding these little things that sometimes really helps me progress in my understanding of how JMP works.
Thanks again for you help on this.