Data missing when a field is null (Vague question, asking for some insight)

[MarcoLuk]

Hello. I know the question might be a bit vague but still would like to ask for your advice.

I encountered an issue that I have a set of data and I want to calculation the summation of them. Yet, when some rows of data has null fields, those rows of data are neglected in the calculation. Does anyone face similar issues before and how did you solve this problem? Thank you

[p_verkooijen]

@MarcoLuk can you provide a sample of the data you have and what you want the output to be?

[marcus_sommer]

You will always need a dimension-value to be able to calculate anything against it. Depending on the data-set, the data-model and the object-dimensionality you may try approaches like:

rangesum(sum(Field), 0)
sum(Field) + sum({1} 0)
alt(sum(Field), 0.000000001)

but it won't work for all scenarios and may resulting in some side-effects.

Another method would be to populate the missing data within the data-model.