6 Replies Latest reply on Oct 16, 2018 10:07 AM by ketki.borawake.0

    Calculating on Null Value

    Ryan Szymanski



      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,