There's no way to answer this question with the information provided.
I'm sorry it wasn't clear. How do I get the 93,798 number which is the last number in the "table" copied over to the bottom right hand field labeled Mod premium? If I say Mod premium = grand total then the first number in the table, 92,346 shows up.
That isn't a meaningful answer to the question.
What kind of field are you talking about?
It sounds like it is a summary field, defined to create a running total.
You want an additional field, defined as a summary field, but NOT set to running total.
It looks like you need to copy data from the last related record in the portal. This assumes that this is an unsorted, unfiltered portal. If it is sorted and/or filtered let us know and we'll take a different approach.
But with an unsorted, unfiltered portal, A calculation using the Last ( ) function can return the value of this field from the last related record.
Thank you Phil, that's exactly what I need...the last related record in the portal. However, it is a filtered portal. Is there an easy way to get that done?
No you do not need to copy from the last portal row. The answer is the same as my previous answer; with one addition.
Create a summary field.
Then create a one row portal with the same filter and place it on the layout. Put the summary field in this portal.
Forgive me but I tried that and result was the same as with the Mod Premium field at the bottom right of the screen. I made it a summary field yet it displayed the first entry; not the last.
You made a new field.
you defined it as a summary field.
in which table did you define the field?
what field does it summarize?
it is NOT defined as running total.
you create a copy of the portal one row high.
You placed it on the layout and made sure its filter was correct and put the field inside this portal?
I made a new field name grand total summary
defined as a summary field
I defined it in the same table that the other fields are based off of
it summarizes "grand total"
it's not a running total
I created a one row high portal
filter is the same
1. Seems to me the summary field should be summarizing the Subtotal field.
2. Then your result (Modified Premium) would Base + Sum of Mods.
The self-compounding totals also seem like a questionable design but I don't really know if that is a valid practice for your business or not.