Can someone help me unstick my brain? I've added a custom currency field to a custom record. Store Value is checked. It is available on the custom form. I have imported data. I want to use this field in a simple formula to subtract this value from another currency field in a formula(text) column in a saved search. When I add the formula (text) or (currency) and add the formula {somefield}-{mynewfield} , I get an unexpected error. When I go to the forumla builder, the new field is not available from the list of fields I can use in a formula. I am using the correct record type to begin the saved search.
What am I doing wrong????