View Calculated Field not in Field List of same view.
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?