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?
The same question
Replies have been locked on this page!