Is it possible to summarise a field only under certain criteria.
I'm trying to use the DistinctCount function to distinctly count (number) records only if they are not equal to zero.
I want to use this ......
DistinctCount ({@NumberValue},{Week})
...... only if {@NumberValue} does not equal "0".
Any help would be much appreciated.
I'm trying to use the DistinctCount function to distinctly count (number) records only if they are not equal to zero.
I want to use this ......
DistinctCount ({@NumberValue},{Week})
...... only if {@NumberValue} does not equal "0".
Any help would be much appreciated.