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.
Nº Hasta | Distinct Count of Date Hasta |
(blank) | 123 |
01/HP/CCM/DP/2015 | 1 |
01/HP/DA/CCM/2015 | 2 |
02/HP/CCM/DP/2013 | 1 |
02/HP/DA/CCM/2015 | 1 |
03/HP/CCM/DP/2014 | 1 |
03/HP/DA/CCM/2015 | 1 |
05/HP/CCM/DP/2013 | 1 |
05/HP/CCM/DP/2014 | 1 |
06/HP/CCM/DP/2014 | 1 |
07/HP/CCM/DP/2014 | 1 |
08/HP/CCM/DP/2014 | 2 |
09/HP/CCM/DP/2013 | 1 |
12/HP/CCM/DP/2013 | 1 |
13/HP/CCM/DP/2013 | 2 |
HASTA N.º 1 | 1 |
HASTA N.º 3 | 1 |
HASTA N.º 5 | 1 |
HASTA N.º 7 | 1 |
Grand Total | 139 |
Nº Hasta | Distinct Count of Date Hasta |
01/HP/CCM/DP/2015 | 1 |
01/HP/DA/CCM/2015 | 2 |
02/HP/CCM/DP/2013 | 1 |
02/HP/DA/CCM/2015 | 1 |
03/HP/CCM/DP/2014 | 1 |
03/HP/DA/CCM/2015 | 1 |
05/HP/CCM/DP/2013 | 1 |
05/HP/CCM/DP/2014 | 1 |
06/HP/CCM/DP/2014 | 1 |
07/HP/CCM/DP/2014 | 1 |
08/HP/CCM/DP/2014 | 2 |
09/HP/CCM/DP/2013 | 1 |
12/HP/CCM/DP/2013 | 1 |
13/HP/CCM/DP/2013 | 2 |
HASTA N.º 1 | 1 |
HASTA N.º 3 | 1 |
HASTA N.º 5 | 1 |
HASTA N.º 7 | 1 |
Grand Total | 21 |
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