View Calculated Field not in Field List of same view.

Laura Corbet shared this question 4 years ago
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?

Replies (1)

photo
1

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

Leave a Comment
 
Attach a file