Changing Display Patterns dependent on other fields
Is it possible to change the display format of one field depending on what is selected/entered in another field?
I.e. we offer two types of discounts, a percentage and a monetary. One requires the zz.zzz% and the other a $zzz.zz format. The display pattern will depend on another field which the user indicates which form of discount is being applied. I would like to combine this all into one field. Is this possible?
I've tried the Format() function, but am having trouble with it.