I have a view of a table that contains a yAmount field.
I left join to a child table that contains adjustments to the parent. It too has a yAmount field.

I sum the values from both tables to a field in the view named yCurrentValue.

In the where I have: where yCurrentValue<>0.00

I receive the error, yCurrentValue is not found

Is there a way to where on a calculated field?

Thanks,
John