View Calculated Field not in Field List of same view.

Laura Corbet shared this question 2 years ago
Answered

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 (0)

Leave a Comment
 
Attach a file