Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hej - I got a probem with counting digits out of a row of digits.
I want to count the digits marked with red = 0100171350104015.
Mabye something lik this....
count ({<AAR={$(vCurrentYear)},item1={'****1713501040**'}>}item2)
But it dosn't work!
How do I do it?
Best regard
Jesper
Try this:
=Count ({<AAR={$(vCurrentYear)}>} If(WildMatch(item1, '*171351040*'), item2))
Or may be this:
=Count ({<AAR={$(vCurrentYear)}, item1 = {"=If(WildMatch(Item1, '*171351040*)"}>} item2)
Hey
Sorry for the late answer, but I was busy!
No one is working - am I right somthing is missing in the latest syntax:
=Count ({<AAR={$(vCurrentYear)}, item1 = {"=If(WildMatch(Item1, '*171351040*)"}>} item2)?
I assume a ' is missing where the red cross is - even thoug is not working!
I left out the counting current year and tryed this:
Count (JOURNALNR = {=If(WildMatch(,'*171351040*')}>} JOURNALNR))
But still its not working!!!
from my small test
a:
load rowno() as item2, * inline [
item1
0100171350104015
01713501040
000001713501040
0171350104015
0100171350104014
1713501040
713501040
171350104
];
count ( {$ <item1={"*1713501040*"}>} item2) --> 6 (bold)
count ( {$ <item1={"????1713501040??"}>} item2) --> 2 (underline)