You need to sign in to do that
Don't have an account?
Account Rollup field - updating
We have a rollup field on the Account object that references a custom table - the intent of this rollup is to pull in the latest value only from the most recently posted month. The rollup today would have filter criteria of (for example) "Posted Date equals 8/9/13". We manually change this rollup each time we upload more data to the custom table.
I'm looking for a way to make this more dynamic, such that the Account obj always pulls in the "latest" data available, without having to adjust the rollup field each time. I tried changing the rollup to instead point to a field on the custom object called "Most Recent", defaulted to one, with an accompanying apex trigger/class to set all prior records set to one back to zero, but this caused contention (DML) issues due to the associated rollup field on the Account.
Any other ideas?
Thanks,
Pete
Here's my trigger...
... and class...