Division by Zero Error

jpootjpoot
edited 1:36AM in FastReport 3.0
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

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

    I have updated to 3.07 and it works fine.

    Thanks.
  • rajraj bangalore
    edited 1:36AM
    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

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 3.0Comment As ...

© Vanilla Keystone Theme 2024