Closed seanrmsy closed 2 years ago
jamesbsfdc
commented
2 years ago Hi @seanrmsy Thanks for reporting this but please can you log a support case as we don't provide support, or accept bug reports, via GitHub Issues.
https://help.salesforce.com/s/articleView?id=sfdo.SFDO_How_to_Create_a_Tech_Support_Case.htm&type=5
seanrmsy
commented
2 years ago I have. Thank you - I didn't realize.
[image: photo] Sean Ramsey 512-801-3630 | @.** "Get busy living, or get busy dying."* - Andy http://linkedin.com/in/seanrmsy http://twitter.com/seanrmsy
On Mon, Aug 1, 2022 at 2:56 PM James Browne @.***> wrote:
Hi @seanrmsy https://github.com/seanrmsy Thanks for reporting this but please can you log a support case as we don't provide support, or accept bug reports, via GitHub Issues.
https://help.salesforce.com/s/articleView?id=sfdo.SFDO_How_to_Create_a_Tech_Support_Case.htm&type=5
— Reply to this email directly, view it on GitHub https://github.com/SalesforceFoundation/Volunteers-for-Salesforce/issues/522#issuecomment-1201648265, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACL4YRRFAZ53AXOXX6WQNITVXATXRANCNFSM55IVLICA . You are receiving this because you were mentioned.Message ID: <SalesforceFoundation/Volunteers-for-Salesforce/issues/522/1201648265@ github.com>
We're experiencing a strange phenomena where the Total Values rollup (VolunteerHoursTrigger) is resulting in negative numbers. I've confirmed that the Volunteer Hours records are either "Completed" or "Confirmed" and the "Number of Volunteers" has a value of 1 or more.
On this Shift...
"Desired # of Volunteers" equals 20. "Total Volunteers" equals -5 "# of Volunteers Still Needed" equals 25 So that's weird right? Even stranger, looking at the Volunteer Hours record, the "Total Volunteers" is 4.
I've manually edited one of the "Volunteer Hours" records, setting the Number of Volunteers to 2 and the "Total Volunteers" incremented to -4. So I believe the Trigger to be working.
A Salesforce Developer and I reviewed the Volunteers for Salesforce code and believe we have spotted a bug with the method which calculates the Total Volunteers. In all cases where we're seeing negative numbers the calculation is SUM (Completed | Confirmed) - SUM (Remaining Records). So if the No. of Cancelled, No Show, etc. records outnumbers the number of Completed or Confirmed records then you'll end up with a negative number.