Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This formula shows all records that fall within the latest date in the set:
count({$<[Date Submitted to TC]={">=$(=max([Date Submitted to TC]))"}>}[Date Submitted to TC])
This formula should show all records that fall within the 7 days prior to the latest date in the set:
count({$<[Date Submitted to TC]={">=$(=max([Date Submitted to TC]))-7"}>}[Date Submitted to TC])
The first formula works, but the second doesn't. I've been tinkering for hours trying to get this to work. Any help would be appreciated. Thanks.
Move -7 within the dollar sign expansion. You might also need Date() function with the date format of Date Submitted to TC
Count({$<[Date Submitted to TC]={">=$(=Date(Max([Date Submitted to TC])-7, 'DateFieldFormatHere'))"}>}[Date Submitted to TC])
Move -7 within the dollar sign expansion. You might also need Date() function with the date format of Date Submitted to TC
Count({$<[Date Submitted to TC]={">=$(=Date(Max([Date Submitted to TC])-7, 'DateFieldFormatHere'))"}>}[Date Submitted to TC])
that fixed it. Thanks.