What is the meaning of this in Set Analysis - {<'*'>} ?

[retko1985]

E.g.   Count(DISTINCT {<Amount1={'*'}>}Year)

Thank you.

[tresesco]

Count(DISTINCT {<Amount1={'*'}>}Year)

Count distinct number of years where Amount1 field has non-null values. I.e. - '*' refers all values except nulls.

[sunny_talwar · Accepted solution]

To expand, if you have data like this

Year               Amount1

2010               10

2011                20

2012                30

2013                 

2014                 50

2015                 60

2016                 70

2017                 80

Where Year 2013's Amount is Null (NOT a blank space, but a true NULL), you would get a count of 7 (excluding 2013)