2 Replies Latest reply on Apr 20, 2018 2:14 PM by Scott Schmeling

    Null in Parameter

    Scott Schmeling

      Good Morning,

       

      Trying to use Null as an option in a parameter.  Here are the formulas I am using:

       

      Determine which number to use: (A-BINB)

      If (IsNull([BINB Count])) Then [Actuals Calculation]

      Else (Int([BINB Count])) + [Actuals]

      End

       

      Actuals Calculation:

      If Int([Parameters].[Month Parameter]) <= Int([Month]) Then Null

      Else

        [A-BINB Count]

      END

       

      The issue is that no matter which Month is in the Month Parameter I end up with a Null in the final column.  This only happens if I use the IsNull- If I use a character for the default for (BINB Count) it works perfectly well.

       

      Any suggestions on why this might be happening.  It makes it a real pain for the Mobile version of the report.

       

      Thanks,