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
Totals: CountIf – ignoring null val
Re: Totals: CountIf – ignoring null val
Hello,
Please try to use the following expression:
{CountIf (Data, SampleData["Al2O3"] <> DBNull.Value)}
Thank you.
Please try to use the following expression:
{CountIf (Data, SampleData["Al2O3"] <> DBNull.Value)}
Thank you.
Re: Totals: CountIf – ignoring null val
Thank you, this works depending on C#/VB using != or <>
Stephan
Stephan
Re: Totals: CountIf – ignoring null val
Hello, Stephan.
Yes, the expression depends on using language.
Thank you.
Yes, the expression depends on using language.
Thank you.