The formula that you have used isn't achieving the same end result that I was getting with my 'If' statement. Your formulaCell3 + Cell4 + Cell5 + Cell6 + Cell7 + Cell8 My formulaif (Table1.HeaderRow2.Cell3.rawValue == null) {this.rawValue = Table1.Row1.Cell3.rawValue + Table1.Row1.Cell4.rawValue + T...

Thanks.  I have got it to work but unfortunately when the row is added the formula isn't updating and therefore is incorrect. Is there some way of getting the formula to automatic update for the inserted line?Jen

I'm aware of how to Add or Delete a Row to a table where the buttons are located within the table (see Sample 1) but can you have the button located at the buttom of a page instead, outside the table (see Sample 2).  If yes, can you please assist me with the scriptingThe reason for this is that I wa...

That is excellent Paul.  Thank you so much for your prompt answer.  Jen

Morning all,I have a document in excel with two formulas that I need to create a similar formula in livecycle designer.Highlighted in red)     =IF($B$6="",B7+C7+D7+E7+F7,B7*$B$6+C7*$C$6+D7*$D$6+F7*$F$6+E7*$E$6)highlighted in blue)     =SUM(G7:G9)/$H$3I have attached the excel spreadsheet along with ...

Thanks Bruce!

I tried the pattern but that didn't work.  If the formula resulted in a negative number i.e. -88 it gave me (-88) but if the formula resulted in a positive number i.e. 88 it would still give me -88.  Jen

Working with formulas, if the amount is negative I would like it to automatically show the amount as (-20) rather than just -20.  Can you please advise me what I need to do.RegardsJenny

Attached is a document where I need to be able to hide text if the check box is selected.  I have been able to achieve this but if a person changes their mine (which is very much a possibility) and they decided to uncheck the box, the text doesn't reappear.Can you please have a look at the scripting...

Expanding further, I have the changed the highlight colour to blue upon opening the doc and turning off upon closing the doc.  Is there anyway that I can have the highlight colour turn off once the field / cell has been enetered?  This will enable our clients to establish what still needs to be ente...