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