Filter on calculated field?

I’d like to have a BAQ that returns rows for only the past fiscal year. I figured out how to create two calculated fields for the first and last day of last year, but don’t see how I can use that to filter rows based on a calculated field. Any pointers?

Add a subquery criteria.

2 Likes

Also, if you take this to a dashboard, it gets kind of wacky. There is a place in the dashboard to filter the BAQ, and it does not let you use your calculated field there, only table fields. But if you right-click on the grid (or tracker, I guess) and look at THOSE properties, it will let you filter by any BAQ field.

3 Likes

I figured out how to solve this in a slightly different way. I can take the expression from the calculated field and in a BAQ you can filter by an expression(paste the formula from the calculated field).

It would be nice if you could filter by a calculated field as you can give the field a name which would help future me or my coworkers to know what it is I’m calculating…

The Subquery Criteria does this. The following limits the results of Subquery1 (the Top Level subquery in my case), to only records where the calculated field NumAndPerson (which is just a concatination of the order num, a ‘-’, and the userid), to be LIKE 21%del%

And returns:

image

Without the subquery Criteria, it returns

image

Thanks so much, totally missed that :slight_smile: