Joker problem

[#1]

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

[sunny_talwar]

Try this:

=Count ({<AAR={$(vCurrentYear)}>} If(WildMatch(item1, '*171351040*'), item2))

[sunny_talwar]

Or may be this:

=Count ({<AAR={$(vCurrentYear)}, item1 = {"=If(WildMatch(Item1, '*171351040*)"}>} item2)

[#4]

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!!!

[maxgro]

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)