I'm trying to create a report to only show the ven...
# suiteanalytics
f
I'm trying to create a report to only show the vendor code used but the Suite Answer they gave me doesn't provide the accurate data and the saved search is showing more then 1 vendor code.
b
So you’re comparing a Report to a Saved Search? What are the filters for both of them? And what kind of components/metrics is the Report vs what kind of Saved Search?
f
Sorry, what I ment to say is that I'm creating a saved search but unfortunately the vendor codes are being shown even when it's not on the Purchas Order. I tried the criteria suite answers gave me , Criteria tab: Type = Purchase Order      Formula(Numeric) > Formula: DECODE({item.othervendor},{vendor.entityid},1,0) > Value = 1 > click Set but I'm not pulling any results for this criteria.
b
hmm DECODE is doing a comparison of the two fields so if they aren’t equal then you won’t get any results? Have you tried just placing those two fields into the Results tab instead of the Criteria tab just to see how many doesn’t match?
message has been deleted