How Can We Help?

Follow

Calculated BidTable Columns

If you have not already reviewed how to create BidTables, please click here first: Creating a BidTable

All Bonfire-generated BidTables automatically include a Calculated Column called Total Cost. Once you have created your BidTable, you can go to the BidTables tab 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 visible)

Hidden Vendor Value columns Please 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. Note under the Formula Builder section we can now modify and change the formula to our liking. The following screenshot describes how a Discount may be calculated:

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. To create a Calculated Column to accurately represent Discounts provided by Vendors, we must first create the correct formula.

Click in the Formula Builder to begin. Next, click Quantity to insert that element, then multiply it by the List Price. Formulate the percentage discount by subtracting the Discount element from 100, then dividing that by 100. That will generate your discount percentage. Multiply your List Price x Quantity against the percentage discount to generate your after-discount pricing.

Once we've modified our formula, it should appear as follows:

mceclip5.png

mceclip1.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: 

mceclip2.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