Filter a View by comparing two fields like a calculation.
For example. I would like to be able to create a view by comparing two separate fields.
- Field1 Equal to Field2...
- Field1, Greater Than or Equal to Field2..
- [Sale_Price] - [Cost] < "500"
- [LastImportDate] = Max of [LastImportDate]
Examples, COST vs SALE PRICE. Create a filter that allows me to show
I couldn't agree more with FJackson. Give us the same triggered actions functionality when building views. Let's take this to the next level folks!
This would be immensely useful for me. It is very frustrating having to generate overly-complex filters to achieve the same results as saying Where [Field1]!=[Field2].
Now that we have Triggered Actions, replacing the logic generation on Views with the far more powerful version that Triggered Actions has would be ideal, and hopefully require less effort to implement than a new solution.