I figured it out.While in CALC under the CLICK option in FORMCALC:this.resolveNode("FieldTotal").rawValue = sum(Field1, Field2, Field3);Worked like a charm.

What I am trying to do is take my button named CALC and when I click CALC I want it to add Field1, Field2 and Field3 together and output the sum to FieldTotal. I know I need to have this done in click for button but I am not sure how to write the javascript for this. Any help is appreciated!!

Thank you both for your Help! Jasotastic81, you pushed me in the right direction and even taught me a few things! Josh, when I saved it as a Dynamic it worked instantly! Thanks again

I am sorry I am still getting nothing... here is a link to the document in my dropbox. Maybe this will helphttps://www.dropbox.com/s/tyx92c34sxc6087/HE%20Loan%20Worksheet.pdf

I inserted the statement just as you have it and I still get nothing. I made sure to have it on Javascript and Exit and my initial subform is invisible. Maybe I am missing a setting?

I am trying to do something simple... I just cant get it to work. I have a drop down list named "ownership" (Which is part of, DOES THE BORROWER HAVE AN OWNERSHIP INTEREST IN ANY OTHER PROPERTY? and I have choices "Y" and "N". When the user selects "Y" I want the subform (which is currently invisibl...

I was able to get the percent side to work, however the 0$ side did not work. I went over it a few times.. Is there another way I could calculate the diff variable??

I have a 2 fields, one is an estimate and one is the actual cost. We are trying to calculate if there was an increase between the actual cost and the estimate. We estimate high so that our actual cost never goes above the estimate. Thus Actual - Estimate = negative number (meaning that the actual co...

That is actually perfect! The only thing I changed was that if it wasn't one of those two it would be blank.Like this:if (lienpos eq "1st Fixed") then          apor + 1.5elseif (lienpos eq "2nd Fixed") then          apor + 3.5else          ""endifThanks so much for your help!

Ok, I am trying to have the CAP RATE: do a couple of things. First side note, in the Lien Postion drop down there are 4 options, 1st Fixed, 2nd Fixed, 1st HELOC and 2nd HELOC. I am trying to calculate the CAP RATE using the APOR if the Lien Position states 1st Fixed or 2nd Fixed only. So the calcula...