Trying to Get Total 'Count of Bills' Minus Bills That Have a Zero $ Balance on Them
I'm relatively new to Qlikview AND have not been using it for awhile...which makes a bad combo for being able to figure out formulas. But I'm eager to get back into it and re-start my learnings. I'd appreciate any help I could get on this formula I'm trying to write 🐵
I've attached an example of my data. 'Bill #' is a key field. I'm trying to get a count of all bills, less ones that have a 'Total Outstanding' of $0.00. So in my example, I have 9 items, but I'd only like to get a count of 5 (omitting the $0.00 records, but keeping the non zero items in count). I'm pretty good at a basic formula like : count([Bill #]) . But much more to it than that, i get confused.