1 of 1 people found this helpful
da = "(" & amount & ")";
case ( in_out = "in";
Filter(da; "$'0123456789.") ;
Thank you so much for your reponse.
I added this code to the calculation of the "amount" field and now when I type an amount in the amount field, the amount only displays 1.00 if the in_out field is set to "In" and it only displays 0.00 if the in_out field is set to "Out". No matter what I type in the amount field, it only displays 1.00 or 0.00 based on the setting in in_out. Incidently, I had to change the first part of the calc to amount as it told me it could not find the field DisplayAmount before it would even let em save the calc. Any ideas why it is not working?
I think Siplus means you have to create a new cal field (DisplayAmount). Have a look in the file.
The downside with that is you need one field to enter the Amount and another to show it...
Another way would be a script that does the formating for you.
Or the easiest way is to just format the field as currency where negative numbers are in brackets, then you dont need the whole in or out thing, at data entry you just write it positive or negative...
Many ways to rome!
test.fmp12.zip 8.6 K