This content has been marked as final. Show 5 replies
I thought using GetSelectedCount(FieldName, True()) was supposed to return the total number of distinct values in a field?
It works for GetSelectedCount(FieldName) where the selected values are returned but I would like to get the total number of values in the field.
* INLINE [
F1, F2, F3
01/01/2012, 01/01/2013, 1
01/01/2012, 02/01/2013, 2
01/01/2012, 03/01/2013, 3
02/01/2012, 01/02/2013, 4
02/01/2012, 02/02/2013, 5
02/01/2012, 03/02/2013, 6
I'd expect GetSelectedCount(F1, True()) to return 2 at all times (as only 2 unique values) but this isn't happening.
Is the only way (?) to do the following instead?
Count (Distinct All F1)