AnsweredAssumed Answered

Conditional Formating

Question asked by canoevalley on Feb 7, 2017
Latest reply on Feb 7, 2017 by canoevalley

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.


Thank you.