Link on view field: Calculated Field
Was trying out the new link on view field functionality for subqueries (https://wiki.yellowfinbi.com/display/yfcurrent/Sub+Queries#SubQueries-linkingviewfields) and it appears it does not work if the join field is a calculated field.
Using the example in the link above, in the subquery, if you create a calculated field that is MIN(Age At Camp) and try to join on that, you get an error when trying to run the report. In my actual use case I couldn't see any query hitting the DB and when it fails, if you select "View SQL", the pop up is blank
I had to get around it by creating a view with a virtual table that returned the MIN(ID) I was looking for
We're using v9.7.1