Ok I had a look at your form (nice form by the way ...good job). The expression you are using to determine the number of instances is not correct....as well when you sum the salaries it is the details subform that has th eiccurance numbers so that needs the * notation. Here is the 1st calc modified
if (details._detail.count < 3) then
You also have the same code on the layout ready and the calc event. No need for both ...just leave it on the calc event and when the user enters the amounts the totals will update.
You are also getting an error when the row initialize .....a partNoScript is being called becuase of script behind the Name field (itis called txtPartNo in your form). My guess is that you copied this from the Purchase Order sample and forgot to remove the scritp from the Initialize and the change event. This field was originally a DD field and that is what was used to populate it.
Hope that helps
Paul, Thanks so much, but not yet a go
The code you suggest works, but does not give me the desired results. Don't I have to use the detail.PTFT? What is happening now is that if the first row details.detail.PTFT = 1 or 2 then it sums all the salaries in the MU employee salary box. If details.detail.PTFT = 3, then it sums all the salaries in the MU student salary box. I want it to evaluate each row individually based on that PTFT and sum in one of the two boxes.
In words, I hope that:
numTotal = sum details.detail.salary where details.detail.PTFT < 3 for all instances of the table.
Additional help? Thanks so much Paul!
I think I misunderstood what you are trying to do ....so if I select full or part time in the PTFT field I need to add all of those salaries into the 1st total. Then total up all of the benefits for the matching rows. Then I need to calculate the salaries of all rows where the user chose Student and calculate those salaries and benefits ....right?
Now you got what I am trying to accomplish. Thanks so much
Lindsay R. Carpenter @ 9-8609
Let me know
zzztest_Pauls.pdf 1.5 MB
Paul, genius! Exactly what I have struggled with for a week now.
As you can see I am a self taught LiveCycle designer (mostly from the adobe forum questions/solutions.)
Can't thank you enough.