Need Override Field to be blank

[KLA]

On layout "A", I have an override field (a number field - no options selected - the "parent" field is a calculation field showing dollar amount) and i use it when i need to force the field to show zero dollars, overriding the calculation. So i enter "0" and it shows $0.00. Basically my question is, how do i make this $0.00 be blank? I'm actually ok with the $0.00 but on another layout," B", i need the field to show up blank because i have layered it (and the parent field) with another field (making them "see-through"). So that only the field with the dollar amount i want shown, will show up. Right now it shows the zero as well over the dollar amount. And i wouldn't mind if it showed up blank on "A".

[tlsparker]

On layout B, you could format the text color of your field to be the same as the background color. This would make the field invisible.

Tom

[email protected]

http://www.tgparker.com/filemaker

[Rigsby]

Right idea – wrong way round – Try this:

Case(Override = "", TextToNum(""), Round (Payment Amount - Time Billing::Monthly Commission, Override), 2)

[Thom]

Yes, modify your calc field:

Case(

[KLA]

Thanks Thom! It works! Someday soon i'll finish this database!

[Thom]

Use TextToNum("") instead of 0. For example:

total(calc,number) =

Case(

[KLA]

The first Tom's suggestion didnt' work because it's the override field i'd need to change the color of and it takes the color of the parent field. But thanks for suggestion.

But Thom - i'm trying to understand your suggestion. Do I put that formula in the caluclation of the parent field? My calculation is as follows: Round(If(IsEmpty(Override), Payment Amount - Time Billing::Monthly Commission, Override), 2)

Will you revise for me?