You can build cost calculation formulas to evaluate supplier bids on the Cost Calculation page.
- Cost calculation field - Enter your primary cost calculation formula in this field, or else use the buttons in the Formula area to build your formula.
- Display type list - Select which format the result is displayed in: Number or Currency.
- Manage secondary calculation - Click this icon to add and manage additional secondary formulas.
- Formula area - Use the arithmetic operators, comparison operators, function buttons, and bid sheet columns to build your formula.
- Test Calculation area - Enter sample values in the fields and then run a test calculation to test your formula.
Arithmetic operators
Use arithmetic operators to create mathematical expressions in your formula. Table 1 describes the arithmetic operators available for building cost calculation formulas.
Table 1. Arithmetic operators
|
Operator |
Function |
|
+ |
Addition |
|
- |
Subtraction and negation |
|
* |
Multiplication |
|
/ |
Division |
|
( |
Left parenthesis |
|
) |
Right parenthesis |
Comparison operators
Use comparison operators to compare values in your formula. Table 2 describes the comparison operators available for building cost calculation formulas.
Table 2. Comparison operators
|
Operator |
Function |
|
= |
Checks if two values are equal |
|
> |
Checks if a value is greater than another value |
|
< |
Checks if a value is less than another value |
|
>= |
Checks if a value is greater than or equal to another value |
|
<= |
Checks if a value is less than or equal to another value |
|
<> |
Checks if two values are not equal to each other |
Functions
Functions are predefined formulas. Table 3 describes the functions available for building cost calculation formulas.
Table 3. Functions
|
Operator |
Function |
|
IF() |
Tests for a condition. |
|
AND() |
Check if all conditions in a test are true. |
|
OR() |
Check if any conditions in a test are true. |
|
MIN() |
Returns the smallest number in a set of values. |
|
MAX() |
Returns the largest number in a set of values |
|
SUM() |
Adds all of the values in the argument. |
|
AVERAGE() |
Returns the average of the values in the argument. |
|
MEDIAN() |
Returns the median of the values in the argument. |
|
ROUND() |
Rounds a number to a specified number of decimal places. |
|
ROUNDUP() |
Rounds a number up, always. |
|
ROUNDDOWN() |
Rounds a number down, always. |
|
CONCATENATE() |
Joins text strings together into one string. |
|
BIDDER() |
Specifies a bidder. |
|
ISBLANK() |
Checks if a cell is blank. |
Bid Sheet Columns
The Bid Sheet Columns area of the Cost Calculation page lists the columns from your bid sheet that you can use to build your cost calculation formula.