https://netsuiteprofessionals.com logo
Join Slack
Powered by
I am trying something new on the saved search and ...
# suiteanalytics
s
I am trying something new on the saved search and not getting thru this, on the below screen I see 60 as needs Attention but when i click on it go to that saved search it shows me 203.
g
Perhaps there is a join that is adding results items.
s
On this link though I put the URL of the search that it is taking me to, so this looks like there is a sign for $5 but it scans $45
g
Can you share the parameters of the search? Filters and results?
s
this is the criteria
this is the result
g
Gotcha, so each item in the summarized saved search is actually going to a different saved search. What are the parameters for Saved Search 3390 for Needs Attention?
Interesting that there are even results in Needs Attention. Perhaps those are records that have a NULL value in 
{custcolcurrent_ship_date}
.
s
message has been deleted
message has been deleted
Yes, need attention has null value in current_Ship_Date
g
Well it does have a join to Customer (Main Line) -> Company Name in results. Joins can add duplicative results in unexpected places. It also has filters for Tax Line, Shipping Line, and COGs line. I would experiment with removing the join first, then the other Lines filters.
Could also double check to see if some other weird box is checked like run unrestricted or run as role.
s
my question here is if the result is 100 that's fine, but then on the first search why does it show 60
i am doing it as Admin, not even permission issue
I can remove the Tax line, shipping line and Cogs line but those are just added to ensure there are no duplicates
g
In the summary formula, add a column, Formula (Numeric):
Copy code
COUNT(DISTINCT {item})
Or maybe:
Copy code
COUNT({item})
s
under criteria?
g
I remember Summary type COUNT and Formula COUNT are different.
Under results.
s
message has been deleted
i would put document number because i need sales orders
g
Use Min or Max as the summary type and use the full SQL:
Copy code
COUNT({number})
or
Copy code
COUNT(DISTINCT {number})
COUNT({...})
should give you the full count, while 
COUNT(DISTINCT {...})
will only count unique values. Summary type COUNT will only count unique values. So when showing a summary COUNT of Item, it will show a count of the unique item names, not a count of the total number of items that fall into the category.
When dealing with something that has all unique values, there won’t be a difference between 
COUNT({…})
and 
COUNT(DISTINCT {…})
and Summary type COUNT. But when dealing with something general like 
{item}
, the numbers can be VERY different.
s
number was document number, items if the same item is repeated 5 times on different sales order, would it give me 5 times or 1?
g
With 
COUNT(DISTINCT {item})
and Summary type COUNT you would get 1. With 
COUNT({item})
you would get 5.
s
Aha , I will need to try count items then
Thanks 🙏 I will update you
g
👍
Just remember to use MIN or MAX as Summary type. If you use COUNT on a Formula that is 
COUNT({…})
, you’ll probably just get 1 as the result. 😂
👍 1
s
Lol yeah I realize that
t
be aware that what you're doing with the formula text <a href> and similar html injections to saved searches is on NS hitlist to be restricted (SuiteAnswers ID 95253)
s
Hmm why would you restrict it though, we want that ability to go to a different search when we click on that, or how else would you achieve this?
All I am trying to do here is get a list of POs that's Coming in Today, Past Due and ones that is missing the Dates
Open in Slack
PreviousNext
Powered by