Search results for query: *

I am trying to figure out how to create a gauge chart in CR that allows me to compare two sales people’s sales in relationship to an input goal. For example, Salesperson1 has a goal of 100000 monthly and sales person two has a goal of 135000 monthly. What I am trying to do is create a report...

PeterDimitrov Thank you very much, this worked marvelously. BaldEagle

Ianoctdec, Not sure this solves the problem. If for example customer 9384766 has an invoice older than 3 years but has none newer than three years I want to see that customer number. If for example customer 3295846 has an invoice older than 3 years and also has one newer than three years...

I am trying to create a record selection formula that will identify my customers (customer table) who have not purchased anything from me for the last three years (Invoice Table). I can select those invoices older than 3 years and get the customer names off of them but many of those have...