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.