OK - so I use parent.parent.reportData.objects.cachedTotalAmount
to try to sum up my estimate list. I get a list(value1, value2, value3) instead of the sum. So I click on "Evaluate Entire text as mathematical expression. Click OK... double check it to see if the checkbox is saved. Nope. Returns back to unchecked.

Any ideas?

Evaluate Mathematical Expression is used then the formala is in the text area. In this case, it is not.

What you want is this:

 parent.parent.reportData.objects.@sum.cachedTotalAmount

or

enclosingReportTable.reportData.objects.@sum.cachedTotalAmount

Notice the @sum.

This stuff is described in the Mathematical Expression area of the Report Engine Guide.

Also, as of 3.2, you don't need to know this nitty gritty. Use a Standard Filter on the Table and in the second pane where you configure the column, select the column (after you've added it to the left side) and chose one of the Summary options.

Ah yes. Thank you for that. Next question - how do I add up totals from Extra fields? I'm assuming I use F-script on tokens... but haven't figured that out yet.

If all the entries in that specific extra field are numbers, then the same technique will work.

enclosingReportTable.reportData.objects.@sum.extra1

Replace extra1 with extra2 through extra12 depending on what you are using.

I'm assuming you are referring to an extra field on the Opportunity.

Thanks again! I'm starting to see how this works. Is it possible to do something like @count to find out the number of items in a list?

If you want to count the total number of objects, you do this:

enclosingReportTable.reportData.objects.count

Objects is a NSArray (Apple Foundation Framework)
NSArray declares a method called count.

HTH
Happy Holidays.

Is there a way to subtract a start date from the complete date? I want to then run an average of the "aging" calculation. How would I do this?

OK - one more question. How do I calculate the average of all Distinct non-null values in a list?

avg([all|distinct] expression)
Average of the (distinct) values in the expression

That's really important as I'm summing up multiple columns of values with some rows that have null values. They are taking my average down a lot.