I have tried to put this calc together but roadblocks are getting in my way.
Here is what I am trying to accomplish.
I have two currency fields. One named Discount Price and the other named Rollback Price.
The Discount Price field is always populated with a discount amount, however, when I want to enter a price in the Rollback Price field, I want the Discount price dollar amount to (text) to turn white. It essentially disappears.
The reason I need this conditional format calc (which I think would be applied to the Discount Price field), is that I will be putting these two fields on the same report layout directly on top of each other. So if there is a Rollback price, the Discount price will disappear from the layout (which is all white). That way only one price shows on the report.
Hope we can figure this out.