I have data in a filtered / sorted portal. The filter on the portal takes an average of the "filtered" data and gives me what I need. I need that number which is an average to be inserted into a field into the database.
Currently doing an on record load script
Go to Portal Row [Select On ; First]
to get what I need because just calling the field gives me an average of the ENTIRE database. This is kind of workload intensive it seems because my records take a bit to load when changing records I have 50k+.
Is there a way to simplify this or offload it onto the server? I tried doing that however the field would not populate seems I have to do the Go to Portal Row.