Sum values including null values from other field

[tayariib85]

Hi Guys,

When I sum Col1 I get 70 instead of 100, it seems that (-) in Col2 not included in the sum. How can I force Col1 to sum all including ?

Thank you 

[agigliotti]

Hi @tayariib85 ,

The sum of Col1 is 150.
Is Col2 a dimension and Col1 an expression as Sum(Col1) ?