I know I can't ask for anyone specific to help me but jjones has been a huge help in implementing formulas I've used in past saved searches.  I've tried the Netsuite support avenue and their response is they can't help me with formulas.

Our situation:

Created a custom currency field called "Available Business" on customer records.  The user submits the total revenue available in the account.  I need to create an opportunity search that takes the Opportunity's Projected Total and divides the Available Business value for a percentage of the business reflected in the opportunity.

I've looked through all the Help doc and tried using the MOD function but all I get is the "Error: Invalid Expression" value in my formula column.  I've tried using this function in the Formula (Currency) and Formula (Percent) fields with no avail.