title: How to Use Multiple Condition in Open Formula in Pentaho Report Designer?
body: <p>For single condition it is correct but if there is multiple condition hard to customize in open formula.
  For example i want grading like A,B,C .I did such but doesn't work? </p>
  
  <p>Code tried:</p>
  
  <pre><code>=IF([total]&gt;90;"A";0 IF(OR([total]&lt;80 ; [total]&lt;=90);"B";0; IF(OR([total]&lt;60 ; [total]&lt;=70);"C";0; )))
  </code></pre>