Hi Experts,
In NPC Fundraising, I need a “Total Gift This FY” rollup. However, the OOTB DPE Rollup calculates the summary based on the calendar year instead of the fiscal year.
Has anyone implemented an FY-based rollup using the standard DPE Rollup? Any guidance would be very helpful.
@Nonprofit Hub@Nonprofit Ask Me Anything (Global) @Fundraising@Agentforce Nonprofit (Nonprofit Cloud)
@Manjula Rajaram Our implementation partner cloned the OOB DPE and calculated the fields to use Fiscal Year instead of Calendar Year. When it came time to generate end of year tax letters (United States), I needed Calendar Year calculations instead of FY. Insted of undoing the partner's work, I made new fields and expanded the DPE to write CY data into fields I could use for total tax year giving. Knowing what I know now, I would leave Salesforce's OOB for Calendar Year and make new fields on Donor Gift Summary for Fiscal Year, then reference Company Fiscal Year data points.