Skip to main content

Hi guys, I've created a process which on the surface seems to work. Essentially calculating the Aggregate Operation = FIRST, for my field 'Campaign Start Date' which is located on the Opportunity for a lookup on there called Brand (which is an Account).

 

However, for a few brands we are noticing that the DLRS field I made is not calculating correctly. For example, one of our brands Abbvie is showing my DLRS field (Earliest Start Date) as 22nd Oct 2020. However, when I review the Opportunity Start Date on one of the opps this brand is associated to, it is showing 3rd Jan 2020? I've noticed this mismatch happening with a lot of opportunities associated to this brand.

 

Any ideas what might be causing this? I've attached the screenshot of my Lookup Summary for reference. Perhaps I'm not specifying something clearly?

 

Happy to elaborate if need be!

 

Thanks!

5 Kommentare
  1. 9. Feb. 2021, 18:19

    Alright gotcha. I've typed in: Campaign_Start_Date__c ASC NULLS LAST

    I've began the Full Calculation so hopefully once complete the figures will be correct! :D

    Thank you so much for your assistance on this.

0/9000