No that didn't work.
I need two things:
1.- Count the correct value per year.
2.- Remove from that count the number that ends with letter "A".
As explain before I put the expresion:
That give me the correct value for 2010 that includes de Machine numbers with "A". It's equal to 318.
If I click on the list box (Year) for example 2012 the value showed on the Machines online it's nos correct. But if I change on the expresion from 2010 to 2013 shows the correct value 349. But click on the List Box (year) for example 2010 shows 225 and not 318.
Any idea how to fix the two things?
I try that to but it's not giving the correct info.
I change a little bit the expression because the colum DATE_MAQUINAS repeats the year on all the maquinas installed on that year:
(DISTINCT if(DATE_MAQUINAS>=2010 and DATE_MAQUINAS<=2013, MAC_NUMBER))
Now the numbers showed on 2013 and 2011 are correct when I click on List Box (year) but on the other ones still the same problem. Non acurate info.
And how can remove the MAC_NUMBER machines that ends with letter "A" from that count?.
THANKS FOR YOUR HELP