Post reply

SSRS (NaN)

  • December 7, 2015 at 1:47 pm

    #323160

    Does anyone know how to replace Nan with O

    I have the following expression:

    =(Fields!F.Value)/((Fields!A.Value) + (Fields!D.Value) + (Fields!C.Value))

  • December 7, 2015 at 5:58 pm

    #1844519

    You are most likely getting a divide by zero happening.

    Add something like this - you may need to check for nulls also - been a while.

    =iif(((Fields!A.Value) + (Fields!D.Value) + (Fields!C.Value)) = 0, 0, (Fields!F.Value)/((Fields!A.Value) + (Fields!D.Value) + (Fields!C.Value)))

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

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