set analysis help

[aaronnayan]

     Hi Everybody

Need a little bit of help with this set analysis expression

In my bar chart that is made for errors. I want to show all desc, PNO, that are less than 9 digits or contain a “?”

IF(LEN(PNO)<9 OR wildmatch( REPLACE(PNO,'?','@'), '*@*') ,LIGHTRED(),WHITE())

This is what I have used

sum({$<ProductCode={"???"}>}SPAMT)

This is for my bar chart to show the number of sales processed with incorrect data

Would it be possible to fuse these two expressions together??

[prieper]

some sample data would be helpful.

Have you taken the first expression for the background? White on White?

The other expression may be correct from the syntax, but am missing the content.

[aaronnayan]

sum({$<ProductCode={"???"}>}SPAMT)

but i want it to also filter for anything <9 charaters

[Anil_Babu_Samineni]

May be this?

sum({$<ProductCode={"???"}, PNO = {'$(=Len(PNO)<9)'}>}SPAMT)

Or

sum({$<ProductCode={"???"}, PNO = {=Len(PNO)<9}>}SPAMT)

[aaronnayan]

no thats not quite right, the 2nd one there is an error the last part

the first one is correct but it is not picking up anything

please help

[Anil_Babu_Samineni]

Is there any chance to share Application for reference

[aaronnayan]

sorry no can do

[Digvijay_Singh]

May be -

sum({$<ProductCode={"*???*"},PNO={"=LEN(PNO)<9"}>}SPAMT)

[Anil_Babu_Samineni]

First, try with this?

sum({$< PNO = {'$(=Len(PNO)<9)'}>}SPAMT)

[sunny_talwar]

May be this

Sum({$<ProductCode={"???"}, PNO = {"=Len(PNO)<9 OR WildMatch(Replace(PNO,'?','@'), '*@*')"}>}SPAMT)