Division by Zero Error

Hi Folks,

I'm getting a division by zero error in the following expression:

[IIF(<frxDataset1."PLAN_ORI_ENE_JUN"> = 0,100,<frxDataset1."VARIACION1">/<frxDataset1."PLAN_ORI_ENE_JUN">*100)]

It suppose avoid zero division but it doesn't work.

Any idea?

Regards.

Comments

  • edited 1:31AM
    It won't work in 3.06 and earlier version. Since 3.07 IIF is macro and it will works well.
  • edited 1:31AM
    Hi Alex,

    I have updated to 3.07 and it works fine.

    Thanks.
  • rajraj bangalore
    edited 1:31AM
    hi ,
    its not working for me.....
    i m using fast report version "2015.1..."
    i wrote this formula
    [IIF(<COMPANY PRODUCT VARIANCE REPORT."RNS"> = 0,100,<COMPANY PRODUCT VARIANCE REPORT."REVENUE">/<COMPANY PRODUCT VARIANCE REPORT."RNS">*100)]
    in my calculated field, can any one help me to solve this issue , i m getting divided by zero error.


    Thanks and regards,


    Raj


Leave a Comment