Post reply

#Error displayed on IIF statement

  • November 5, 2008 at 9:27 am

    #195664

    Here is my IF statement:

    =iif(Fields!PROD_MIN.Value > 0, Fields!THROUGHPUT.Value / (Fields!PROD_MIN.Value / 60), 0)

    result: When PROD_MIN is > 0, calculation is done, but when its zero, it display #Error

    I even tried replacing the False part from 0 to "0", but still returns #Error.

  • November 5, 2008 at 10:01 am

    #894376

    is250sp (11/5/2008)

    Here is my IF statement:

    =iif(Fields!PROD_MIN.Value > 0, Fields!THROUGHPUT.Value / (Fields!PROD_MIN.Value / 60), 0)

    result: When PROD_MIN is > 0, calculation is done, but when its zero, it display #Error

    I even tried replacing the False part from 0 to "0", but still returns #Error.

    Follow this link for more insight and suggestions:

    http://qa.sqlservercentral.com/Forums/FindPost537962.aspx

    HTH

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • November 5, 2008 at 10:21 am

    #894405

    thanks toolman! great information

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply