1 Reply Latest reply on Nov 6, 2012 5:01 AM by Alex Kerin

    Calculating on Null Value

    Ryan Szymanski

      Hello,

       

      Does anyone know if/what filters need to be adjusted so that null values are calculated within a calculated field.

       

      Have created a table calculation where the sum of %MV is calculated against the 'First'

      Ordered as a table calculation, blank values are assumed to be 0.00, and all fields are applied in the calculation.

       

      Though as soon as a parameter is introduced to run a calculated field 'PLAY; find that %MV values that were blank are ignored in the calculated field. Hoping to have all values (including blanks) calculated upon, does anyone know if/how my calculated field OR filter settings could be adjusted.

       

      Thanks in advance,