At the moment, shotgun can’t use query fields in calculated fields.
You also can’t use linked fields in calculated fields, which is a massive obstacle for us in a lot of cases.
We can make duct-tape solutions using the API, but has anyone found a way to get around this with general use of the UI in shotgun?
But we are still missing the query fields in Calculated Fields.
For example: we have a currency field on Bookings (Crew Planning), so on the Project we created a Query Field that makes the Sum of all Bookings. But from there we cannot calculate anything else from that field…
Having support of Query Fields in Calculated field would be VERY helpful.
This is one of the last feature we would need to completely drop the SG Daemon for Budget calculation