How to create a calculated column ?
Print
Modified on: Wed, 8 Nov, 2023 at 5:26 PM
Calculated Column: Price Manager allows you to add Calculated Columns with user defined SQL logic stored in the Worksheet. To create a calculated column please follow the steps below.
- Click on worksheet properties tab from the common operators filed.

- Click on "Manage Column" and select add a "Calculated Column"

- Once you clicked on "Add Calculated Column" a new window will open like below. ( Just as an example lets add a calculated field for Profit )
- You can also pull out the hidden columns available in the entity by enabling "Show Hidden Columns" if it helps to calculate the field.
- Column Name : Profit CC (1)
- Display Format : Depending upon the field that needs to calculated select the appropriate option from Integer,Float,Currency,Percentage (2)
- Decimals : Upto which decimal you would like to view the value. (3)
- Column Defination :Calculated Columns use SQL logic as the basis for their code. Samples of SQL logic are available in the another Freshdesk solution (4). Add a suitable formulla to calculate the desired field.
- Click "Save"

- Calculated columns are highlighted in "Green colour" on the worksheet once saved.

Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.