Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear friends,
I need a formula that has a distinct count of Nº Hasta without blanks with another criteria distinct count of Date Hasta as figures below.
May be this:
Count(DISTINCT {<[Nº Hasta] = {'*'}>} [Nº Hasta])
Instead of Count(DISTINCT {<[Nº Hasta] = {'*'}>} [Nº Hasta]) i change for Count(DISTINCT {<[Nº Hasta] = {'*'}>} [date Hasta]) and it works.
Many thanks
Awesome
