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

Topic: Error:Invalid floating point operation

I add code in report but error

[SUM(<Report."CCC">,0,1)/(SUM(IIF(<Report."AAA"><>'',1,0),0,1)+SUM(IIF(<Report."BBB"><>'',1,0),0,1))*100] %

how to fix ?

My Visual Database : I Love You
Easy For Beginner Student For Me

2 Reply by prahousefamily (edited by prahousefamily 2016-03-04 07:54:42)

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

Re: Error:Invalid floating point operation

How Ti Fix
Form
http://forum.vingrad.ru/topic-257434.html

0 / 0 - Invalid floating point operation
1 / 0 - Divizion by zero


I Can get Answer For Fix Error
By Check Value Before Cal
if value >= 0  then calculate else 0 

IIF(
SUM(<Report."CCC">,0,1),0,1)<>0) 
and
(SUM(IIF(<Report."AAA"><>'',1,0),0,1)+SUM(IIF(<Report."BBB"><>'',1,0)<>0)
,SUM(<Report."CCC">,0,1)/(SUM(IIF(<Report."AAA"><>'',1,0),0,1)+SUM(IIF(<Report."BBB"><>'',1,0),0,1))*100,0)

Thank You Everybody For Read...

My Visual Database : I Love You
Easy For Beginner Student For Me