Forum Discussion
Why is my formula not working correctly
I have used a formula to find items over $1,000 and not in a session and while it finds some items correctly its still finding items that are on the sessions and still displaying as not on a session....
When you can the text to column it removed any preceding zeros in an invoice number which will also make the same mistake because the data on the other tabs should have the preceding zeros.
Then you'll have to clean the data manually - not a pleasant task...
