[Date] is a field that holds a date (duh). [Id] is the primary key of the table. Essentially, I am just trying to find out how many records have a specific date between 5 business days ago and now.
When I break it down, it seems like it should work:
Max([Date]) = 7/28/2019. This is correct.
FirstWorkDate(Max([Date]),5) = 7/22/2019. This is also correct.
Yet when I try the whole formula, I get an undefined value ("-").
I did* try changing the Max([Date]) to RangeMax([Date]), but that ends up returning a value that's way too high.
I also tried creating a variable for FirstWorkDate(Max([Date]),5), then including it in the original formula, but that gives me a nested aggregation error.
