View Calculated Field not in Field List of same view.
Completed
I created a calculated field in a view. I then wanted to use that calculated field in a second calculated field in the same view but the first calculated field is not available in the drop down.
As a work around, I am using virtual tables to freehand SQL the calculation and then reference the output in calculated field, but doesn't seem efficient.
In reports, I AM able to reference calculated fields in new calculated fields, just not in the view. Is this the way the system functions?
Can you attach a screenshot of your problem. There are some places I am still not clear on. Take a look at this related issue and see if it can help you.
https://community.yellowfinbi.com/knowledge-base/article/differences-between-simple-and-freehand-sql-calculated-fieldssubway surfers
Can you attach a screenshot of your problem. There are some places I am still not clear on. Take a look at this related issue and see if it can help you.
https://community.yellowfinbi.com/knowledge-base/article/differences-between-simple-and-freehand-sql-calculated-fieldssubway surfers
Replies have been locked on this page!