Formula(Date) :
Summary Type : Maximum
Description : coalesce(max(case when {systemnotes.field} in (‘Pipeline stage’) and {systemnotes.oldvalue} in (‘Opportunity’) then {systemnotes.date} when {systemnotes.field} in (‘Deal Status’) and {systemnotes.newvalue} in (‘Won’, ‘Lost’)then {systemnotes.date}end ), current_date )
available filter : Internal Id