topic Sum previous date record count in App Development

Sum previous date record count

Andrew_2020 — Sat, 23 Sep 2023 15:48:21 GMT

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)

Re: Sum previous date record count

kkarlste — Sat, 23 Sep 2023 15:53:36 GMT

This not working

Re: Sum previous date record count

kkarlste — Sat, 23 Sep 2023 16:01:36 GMT

This working bus I must show label colum MonthYear

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

Re: Sum previous date record count

Andrew_2020 — Mon, 25 Sep 2023 15:24:03 GMT

You're also missing a '

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

This however results in zero.