Case statement using date field
I am looking to do case statement summing a column based off the most recent date in a date column. Below is my attempted beast mode calculation. The calculation keeps returning zero as the result. 4/20/19 is the most recent date in my date column so anytime it finds that date I want it to sum the value in the 'Greater than 70 Days' column.