If statement condition not calculating

acbishop2 — Sat, 16 Nov 2024 20:21:57 GMT

Can someone tell me why this isn't working?

Count(If(Floor([Date]) >= FirstWorkDate(Max([Date]),5),[Id]))

[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.

I appreciate the help in advance.

Re: If statement condition not calculating

Lisa_P — Tue, 30 Jul 2019 04:18:37 GMT

Try re-arranging this :

If(Floor([Date]) >= FirstWorkDate(Max([Date]),5),Count([Id]), 0)

topic If statement condition not calculating in App Development

If statement condition not calculating

Re: If statement condition not calculating