- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Couple of things:
1. The sum command has capital S so it is Sum() not sum()
2. There is no space between Sum and the (
3. When you reference the other fields they are in a different subform than the total, so you must path to the fields. The easiest way to do this is in the Script Editor put the cursor where you want the reference to appear, then hold ctrl down and move the cursor to the desired field. The cursor will change to a V. Release the mouse when you are on the field and the correct reference will be written into the script editor.
4. You cannot split the command across two lines ...keep it all on one line.
I have included my modified version. I only did the 1st table.
Paul
Views
Replies
0 Likes
Total Likes