I have a view that holds the data per student per class that has attended a course.
We charge a different rate for the first person than we do for the 2nd, 3rd, 4th and so on.
The first person registered is at full price, but each additional student is 30% of the full value per class.
So, what I did was to create a running total for each student(grouped by class offering and then by customer) and then created a formula that says if the running total (which is a count of the student name field in these groups) = 1 then 'full price' if not, then full price * .30
So, I can see the correct value in the detail section we are charging to the customer, but what I need is to total these values (which are stored in the details section), but I can't.
I think, logically, I understand why - because the running total is showing AFTER it needs to be calculated...so, my question is how can I get a grand total and/or subtotal for my two groups on this new cost field?
Any help/guidance is much appreciated.
Thanks
Jeanette
We charge a different rate for the first person than we do for the 2nd, 3rd, 4th and so on.
The first person registered is at full price, but each additional student is 30% of the full value per class.
So, what I did was to create a running total for each student(grouped by class offering and then by customer) and then created a formula that says if the running total (which is a count of the student name field in these groups) = 1 then 'full price' if not, then full price * .30
So, I can see the correct value in the detail section we are charging to the customer, but what I need is to total these values (which are stored in the details section), but I can't.
I think, logically, I understand why - because the running total is showing AFTER it needs to be calculated...so, my question is how can I get a grand total and/or subtotal for my two groups on this new cost field?
Any help/guidance is much appreciated.
Thanks
Jeanette