I'm drafting a form to have an excel style table do some simple budgeting calculations but in adobe. I'm about to tear out my hair because I can't figure out why it isn't functioning properly. I'm a completely self-taught designer so it could be something very basic that I'm missing.I have a subform...

@ScottDM Perfect, thank you.

I've tried everything suggested in this string and nothing has worked. I still have the same problem. Crashes on the second preview attempt.

Hi MinusZero,Sadly, I didn't find anything that translates to the column instance creation. It does give me some solutions for future things I want to do with this form. Just doesn't cause the sum calculation work for created columns. Thanks though!

I've got the row subtotal to work$.rawValue =  Sum(Sum(Row3[*].ColX[*].Cell4[*]) + Row3.Cell3)Still need a formula that totals the column when it is one of the dynamically created ones.I tried this:$.rawValue =  Sum(Row3[*].ColX[*].Cell4[*]...Row19[*].ColX[*].Cell4[*])and $.rawValue =  Sum(Row3.ColX...

Hi All,I have a form that I'm building where the table expands by columns and not rows. I have the instances set up and the columns are added or removed by the user with no problems. What I want to do is have a column that subtitles each row. I know how to do subtotals when I'm working with tables t...

Dove into FormCalc and answered my own question.var pDate = Date2Num(Date A.formattedValue,"MM/DD/YYYY")var mDate = Date2Num(Date B.formattedValue,"MM/DD/YYYY")var kDays = mDate - pDateif (kDays >= 90) then Num2Date(mDate - 15)elseif ((kDays >= 30) & (kDays<= 89)) then Num2Date(mDate - 10) else Num2...

Hi Everyone!I have a complicated form situation. I'm trying to have it calculate when a person can start working on a report (Date C) based on the day a project ends (Date A) and the day the report is due (Date B). We have a set scale for when the Date C should be based on the difference between The...

Can you post your form? I've done similar things before and I think I have a solution. I just want to be sure I'm understanding the situation.