Contents
 eSalesTrack Help Menu
    User
       Getting Started
          New User Guide
          Default Modules
          Contact Manager Template
          Business to Consumer Template
          Business to Business Template
          CRM Lite Template
          CRM Product Manager Template
          CRM Template
          Tools
          My Information
             Personal Preferences
                Change Password
                Edit Information
          Home Page
             Creating Dashboards
                Creating Widgets
                   Appointment
                   Graph
                   Links List
                   Task
                   MiniReport
                Publish Dashboard
                Subscribing to Dashboards
             Search
             Libraries
             History
             Quick Access
                My Documents
                   Upload Documents
                   Publish Documents
                   Subscribe to Documents
                Team
                My Email
                Recycle Bin
       Modules
          Types of Modules
          eView
             Editing Records in eView
             Search eView A-Z
       Data
          Reports
             Creating Reports
             Report Manager
             Edit a Report
             Copy a Report
             Clone a Report
             Publish a Report
             Subscribe to a Report
             Delete a Report
          Creating New Data
             Creating Records
                Primary Records
             Editing Records
             Cloning Records
             Collapse Sections
          Views
             What is a view
             Creating a View
             Searching for Records
             Creating Reports from a View
             Creating a View to Show all Records
             Manage Views
                Clone Views
                Copy Views
                Publish Views
                Subscribe to Views
             View Groups
                Editing View Groups
          Manage Data
             Deleting Records
             Recycle Bin
             Activate Records
             Inactive Records
                Activate Records from the Recycle Bin
                Activate Records from the Profile Page
                Inactive Records View
             Permanently Delete Records
             Exporting
             Importing
                Formatting an Excel Spreadsheet for importing
                Import Troubleshooting
                Import Log
       Activity
          Task
             Creating a Task
          Calendar
             Request Additional Calendars
             Sharing Calendar
          Appointments
             Creating Appointments
             Recurring Appointments
       Email and Marketing
          Templates
             Creating Document Templates
             Using Document Templates
             Creating Email Tempaltes
             Using Email Templates
             Image Gallery
             Click-Through Links
             Word Plugin
          Automation
             Add Notification
             Manage Notifications
          Email
             Email Settings
                SMTP
                Setting Up Your E-mail in Microsoft Outlook - POP 
                Setting Up Your E-mail in Microsoft Outlook - IMAP 
             Mass Email
                Mass Email Queue
             Sending Emails
             Creating Email Campaigns
             Outlook Plug-in
             Outlook Plug-in Troubleshooting
       Training
          Free Daily Training Webinars
          eSalesTrack Advanced Customer Services
       Mobile
          Additional Tabs
          Adding Tasks
          Editing Records
          Finding Records
          Adding Appointments
    Administrator
       Modules
          Add Module
             Normal Module
             URL Module
             Delete Module
             Stacked View
                Sales Funnel
             View Only Module
          Field Creator
             eFormula
                Creating an eFormula Field
                Formula - Date
                Formula - Text
                Formula - Currency and Numeric
                Formula - Converting
             Creating Fields
                Picture Fields
             Editing Feilds
             Field Creator
          Unassigned Records
          Form Manager
             Layouts
                Creating New Layouts
                Assigning Layouts
                Multi-page Layouts
                   Multi-page Layouts
                   Linear Layout
             Putting Fields on Form
                Adding One to One Fields
                Adding Parent Fields
             Key Fields
             Sections
             Form Objects
             Additional Tabs
                Activities Tab
                Content Tab
                Email Tab
                Notes Tab
                Team Member Tab
                Deleting Tabs
          Mapping
             Add Mapping
          Portal and Web Forms
             Create a Web Form
             Manage Web Fomrs
             Hidden Fields
          Relationships
             View Relationships
          Mobile
             Mobile Layouts
             Mobile Settings
       My Company Profile
          Company Profile
          Locations
       Display and Themes
          Change Header
          Change Colors
       Company Information
          Subscriptions
             Manage Subscriptions
             Delete Subscription
             Subscriptions
          Users
             Creating Roles
             Sharing Records
             Assigning Roles
             Add User
             Groups
             Reassigning Records
             Manage Users
             Inactivate User
    Videos
 Welcome


LinkIndexPrint

Home > eSalesTrack Help Menu > Administrator > Modules > Field Creator > eFormula > Formula - Currency and Numeric

eFormula

Currency and Numeric Formulas

A formula - currency field will allow you to create a formula and have the end result formatted as a currency field.    Formula - Numeric will allow you to create a formula and have the end result formatted as a currency field.   The end result must be a number or the field will not pull the information.  You can only use numeric fields in these equations.

You can copy and paste these formulas into the formula box.  Drag and drop your numeric fields to replace "field".  You can also put numeric values in place of fields.

 

Sum

The sum function will add all of the fields that you have inside of the formula.

 SUM()

  SUM(¦revenue¦)
   
 

Product

The product function will multiply all of the field values inside the formula.

 PRODUCT(field,field)

  PRODUCT(¦price¦,¦quantity¦)
   
 

Sum Product

The sum product function will return the sum the product of the fields in the formula.

 SUMPRODUCT(field,field)

  SUMPRODUCT(¦revenue1¦,¦revenue2¦)
   
 

Average

The average function will return the average of the values of the fields in the formula.

 AVERAGE(field,field)

  AVERAGE(¦price¦)
   
 

Minimum

The min function will return the smallest value from the set of fields specified.

 MIN(field,field)

 

MIN(¦revenue¦)

   
 

Maximum

The max function will return the largest value from the set of field specified.

 MAX(field,field)

  MAX(¦revenue¦)
   
 

Exponent

 Calculates the result of a number raised to a power.

 POWER(number,power)

  POWER(¦number¦,¦power¦)
   
 

Future Value

 The future value function will return the future value of an investment based on periodic, constant payments and a constant interest rate.

FV(rate,nper,pmt,pv,type)

  FV(¦rate¦,¦#ofpayments¦,¦payment¦,¦price¦,¦paymentdue¦)  rate= the interest rate per period. nper= number of payments in each period. pmt= payment made each period. pv= present value or what the series of payments is worth now. type= 0 if payments are at the end of the period, 1 if payments are at the beginning of the period.
   
 

Interest Rate

The interest rate formula will return the interest rate for a fully invested security.

INTRATE(settlement,maturity,investment,redemption,basis)

  INTRATE(¦settledate¦,¦maturity¦,¦investment¦,¦redemption¦,¦basis¦)  settlement= security's settlement date. Maturity= the security's maturity date. investment= the amount invested in the security. Redemption= the amount to be received at maturity. Basis= type of day count basis to use. 0= US 30/360. 1= Actual/actual. 2= actual/360. 3= Actual/365. 4= European 30/360.
   
 

Payment

Calculates the value of a loan payment with constant payments and constant interest rate.

PMT(rate,nper,pv,fv,type)

  PMT(¦rate¦,¦#ofpmts¦,¦price¦) Rate= interest rate. Nper= number of payments. Pv= the present value or current price. Fv= The future value, if left blank then assumed to be 0. Type= 1 or 0 indicates when payments are due. 0 or omitted at the end of the period.
   
 

Net Present Value

Calculates the net present value of a series of cash flows based on a discount rate.

NPV(rate,value1,value2...)

  NPV(¦rate¦,¦investment¦,¦Revenue1¦,¦Revenue2¦)  Rate= discount rate. Value= the values of the cash flows.
   
 

Random Number

Returns a random number in between 0 and 1.

RAND()

   
   
 

Rounding

Rounds a number to a specific number of digits.

ROUND(number,num_digits)

  ROUND(¦grossmargin¦,2)  Number= number to be rounded.  Num_digits= the number of digits you want the number rounded to.

See also