Post reply

Help issue with iif and basic mathematical functions

  • August 7, 2019 at 2:41 pm

    #3669511

    Isnumeric() isn't perfect. You could get a positive result with a value that can't be used in mathematics. Check your data.

  • August 7, 2019 at 2:59 pm

    #3669523

    Many thanks for your reply

    The value of Textbox1 will either be "-" or numeric

    if I change the formula to read

    =iif(reportitems!Textbox1.value="-","Not A Number",reportitems!Textbox1.value-1) i still receive the same error as before. but this time in reverse it shows "Not a Number" when the value of Textbox1 is "-" and #Error for the sum if I remove the -1 then it displays correctly

     

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

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