Lucas
03/06/2020, 7:46 AMCharles Boyer
03/06/2020, 1:43 PMCharles Boyer
03/06/2020, 1:43 PMAria Ghahari
03/11/2020, 5:56 PMFormula (Date) | Summary Type: Maximum | CASE WHEN {type}='Sales Order' THEN {trandate} ELSE '01/01/1900' END
Something along those lines will gave you the latest associated sales order date. @Charles Boyer’s solution is good also. It gives you days since it was last ordered.