Adding a Formula Column

  • Last update:April 09, 2024
  • Overview

    Version

    FineBI VersionFunctional Change
    6.0/
    6.0.2

    Added the entry to, and changed the name of Formula Column.

    Optimized the interface.

    Application Scenario

    Using formula functions to obtain new fields by calculating the original fields without affecting the original fields.

    Function Description

    You can calculate by using basic arithmetic operations, common functions, numeric functions, date functions, text functions, logic functions, and other functions.

    1fd1d35a23484f4a9e4f48b49b25e49.png

    Example 1: Average Calculation

    You can download the sample data: Contract Information.xlsx.

    You can add the Contract Sum and Purchase Quantity fields to a formula to calculate the average price of each contract.

    1. Create an analysis subject and upload the sample data Contract Information. Go to the data editing page.

    2. Add Formula Column (two methods), as shown in the following figure.

    394ce834cffee84bffec354eaf1f027.png

    3. Select a formula/function. Use the formula Contract Sum/Purchase Quantity to create a field named Average Price. Select the field type as Value, as shown in the following figure.

    iconNote:

    1. The value of the field type is Auto by default. In this case, the system automatically judges the field type based on the generated results.

    2. The added fields need to be selected from the left column.

    6465f56fd5229001f802e16753df74c.png

    4. In the formula input box:

    You can search for fields or functions by entering the first letter or first word.

    You can click functions or fields on the left to add them to the input box.

    68e422a6486255d88c1ae94cd44b4a8.png

    5. Click OK. You can see the newly added data column Average Price in the data preview box.

    d4482323d14515857c6f8cc65b4bc6b.png

    Example 2: IF Function Usage

    In addition to using simple basic arithmetic operations, you can also add the formula column with functions.

    The example background: For instance, a contract is defined as Major Contract if its monetary value exceeds 1,000,000, otherwise, the contract is defined as Minor Contract.

    The implementation approach: You need to use IF Function as the judgment condition, add a formula column, and enter the formula.

    Procedure:

    1. Create an analysis subject and upload the sample data Contract Information. Go to the data editing page.

    2. Add Formula Column.

    4746115352b77f8333b05c217f6d3d9.png

    3. Name the newly added formula column as Contract Size Labeling. Enter the formula: IF(Contract Sum>1000000,"Major Contract","Minor Contract"), as shown in the following figure.

    4a55ba27eda2c4860301f5d4f55f04b.png

    4. Click OK. You can see the Contract Size Labeling field, as shown in the following figure.

    1c3636f2de545ea8ef7db48350e4d25.png


    附件列表


    主题: Adding and Editing Data
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy