• Registered: 2014-02-17
  • Posts: 365

Topic: How To Fix Or Edit Script Error 0/100

in report if  want ratio calculator
(A/B)*100

(5/200)*100 = 2.5
-- OK Normal result  Not Error
(A <>0 or A not null ) AND (B <>0 or B not null )

BUT

(0/100)*100 or (null/100)*100  or (null/null)*100
-- result Error And Report Engine Stop Running

how to protect or check value A,B before cal ?

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How To Fix Or Edit Script Error 0/100

Please attach your project.

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: How To Fix Or Edit Script Error 0/100

Example Error
When Cal In Report

https://s1.postimg.org/34qz787utb/2017-11-01_05_17_07.png

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How To Fix Or Edit Script Error 0/100

I need the project, not a screenshot.

Dmitry.