Screenshot of how that woud work? I don't think yo...
# suiteanalytics
k
Screenshot of how that woud work? I don't think you can do formulas in a filter
j
Lander is correct here. If you add a formula field to the criteria and then add that same formula type to the filter, it will allow you to search on that formula result via the filters.
k
Oh I have got to try this...
j
Yeah it's a pretty neat trick. I think it'll only work with one formula field though (or maybe one of each type?). So it's good, but then users think that their wildest dreams are possible and you have to go around bursting everyone's bubble or contorting your searches in wacky ways to assuage them.