Totals: CountIf – ignoring null val

[StepTK]

Hello,

if we count the number of used values of a column in a DataBand, we want the cells that contain no value (null) does not count.

The formula
{CountIf (Data, SampleData.Al2O3 > 0)}
works, but 0 can also be an allowable value.

The ideal would be the formula with the condition "<> Null"
{CountIf (Data, SampleData.Al2O3 <> Null)}
but so returns no result.

Is there a solution?

Thanks!

Stephan

[Alex K.]

Hello,

Please try to use the following expression:
{CountIf (Data, SampleData["Al2O3"] <> DBNull.Value)}

Thank you.

[StepTK]

Thank you, this works depending on C#/VB using != or <>

Stephan

[HighAley]

Hello, Stephan.

Yes, the expression depends on using language.

Thank you.