Calculated Field Display Parameters

Epicor ERP 10
,
1

Hello,

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!

Thanks!

2

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.

3

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