Can a calculated field reference a calculated field?
So if one creates a calculated field as part of a report, can one then create another calculated field that references the first one? When I tried, the first calculated field did not appear among the columns available in the design dialog box (the first calculated field is already part of the report design). Seems counterintuitive as this is not an issue in other BI programs. I'd be as surprised if one couldn't use a function as an argument to a function.
Am I missing something?