Calculated Field Display Parameters



Is there a statement that allows display parameters within a calculated field?

I have a field that calculates a percentage based off of two other calculated fields and I would like the BAQ to only display negative percentages.

Any help would be greatly appreciated!


You could always make your query a CTE and then add a Top Level query to return the results of the CTE and filter that field for negatives only.

Also, check out the SubQuery Criteria tab. You can filter on calculated fields there.