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,