divide and subtract variables in calculated column

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I am trying to create a bar graph by using calculated column. In calculated column i have added some variables and in order to calculated desired result i am performing some arithmetic operations on those variables.   But it seems that arithmetic (/ and -)operations are not working on those variables. Attached screenshot of the calculated column. Let me know how can i make it work. Thanks in advance. 


Photo of Gaurav

Gaurav

  • 50 Points

Posted 3 years ago

  • 0
  • 1
Photo of Gaurav

Gaurav

  • 50 Points
Hello Team, Awaiting your response as it's really urgent. Please let me know if you need more information. Thanks.
Photo of Jack

Jack, Champion

  • 50 Points
Hi,

Try making 3 formula/summary fields to give you the results and then apply the field1/(field2-field3) calculation in the calculation field.

Regards

Jack