

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
set analysis help
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??


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sum({$<ProductCode={"???"}>}SPAMT)
but i want it to also filter for anything <9 charaters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this?
sum({$<ProductCode={"???"}, PNO = {'$(=Len(PNO)<9)'}>}SPAMT)
Or
sum({$<ProductCode={"???"}, PNO = {=Len(PNO)<9}>}SPAMT)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there any chance to share Application for reference


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry no can do

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be -
sum({$<ProductCode={"*???*"},PNO={"=LEN(PNO)<9"}>}SPAMT)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
First, try with this?
sum({$< PNO = {'$(=Len(PNO)<9)'}>}SPAMT)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Sum({$<ProductCode={"???"}, PNO = {"=Len(PNO)<9 OR WildMatch(Replace(PNO,'?','@'), '*@*')"}>}SPAMT)
