Sum previous date record count

[Andrew_2020]

Creating a snapshot for our database and using RUN_DATE as the date in which each database run is completed. I need to sum values based on max date -1 (previous day totals)

Currently WORKING Max Date Sum:

Sum( {<RUN_DATE={'$(=Max(RUN_DATE))'}>} RECORD_COUNT)

How can I run the previous days totals? I'm used to seeing something like date(max(RUN_DATE)-1)

[kkarlste]

This not working

[kkarlste]

This working bus I must show label colum MonthYear

Sum( {<RUN_DATE={'$(=Max(RUN_DATE))'}>} QC_EvaluationResult)

[Andrew_2020]

You're also missing a ' 

Sum({<RUN_DATE={'$(=Max(RUN_DATE))-1'}>}RECORD_COUNT)

This however results in zero.