How Can We Help?

Follow

Calculated BidTable Columns

If you don't have your BidTable created yet, click here.

If you've already created your template, then by default, there is a Calculated Column already in your BidTable template called Total Cost. You can go to the BidTables section and click Actions → Edit to open and view it:

Image_2018-05-29_at_10_05_42_AM.png

When adding a new calculated column you can choose between three options:

Visible calculated columns (can only refer to other visible values)

Hidden calculated columns (can reference any values ie. hidden or not)

Hidden Vendor Value columnsPlease note that you can only add Vendor Values after your project has closed and there is a minimum of one vendor submission. If you'd like to learn more about Vendor Values click here.

Image_2018-05-28_at_4_25_23_PM.png 

 

For this example, we'll add a discount component to our existing formula.

In this example, we are going to create a visible vendor column. In the BidTable edit screen click Add Column and select Vendor Column:

Image_2018-05-28_at_11_25_16_AM.png

We're going to create a new Vendor column called "Discount" and assign it a Currency format. The "order #" defines the location of the column under vendor columns:

Image_2018-05-24_at_11_35_14_AM.png

Now we're ready to customize our calculated column. Under the Total Cost column you would click on the Edit icon: 

Image_2018-05-28_at_11_24_36_AM.png

This will cause the Edit Calculated Column window to pop up. From here let's observe the default formula for the total cost column. Note under the Formula Builder section we can now modify and change the formula to our liking:

Image_2018-05-28_at_11_15_57_AM.png

The blue tags that define each vendor/purchaser columns are clickable and can be used to add values into your formula.

NOTE: The formula builder uses standard BEDMAS operations. If you input any invalid characters you will see an "Invalid formula" message under the Preview header. 

Next we are going to modify the formula under Formula Builder by adding the minus "-" and clicking on . Once we've modified our formula, it should appear as follows:

Screenshot_2018-05-28__12_27_PM.png

On the right side of the window there is an Example section where you are able to test out your new Calculated Column with its custom formula:

Image_2018-05-28_at_10_14_14_AM.png

Whether you are adding a hidden or visible calculated column you will be able to modify the calculation in the same way as the example shown.

Bonfire Support Hours: Monday - Friday 8:00am - 8:00pm EST

Call Bonfire Support: 1-800-354-8010 ext 2