Forum Discussion
jjmauras
Advocate II
Advocate IIShow a field that has no value
I'm trying to create a graph that shows the number of Orders created this year compared to the number of Quotes created this year by customer service rep. The first part of my graph is the number of ...
Is your data coming from an exteral database? if so you could modify the view you are using to ensure all reps are returned and use something like
SELECT ISNULL(myColumn, 0 ) FROM myTable
To ensure no null values
itchyeyeballs
Impactful Individual
Impactful IndividualIs your data coming from an exteral database? if so you could modify the view you are using to ensure all reps are returned and use something like
SELECT ISNULL(myColumn, 0 ) FROM myTable
To ensure no null values
ALeef
Resolver II
Resolver IIitchyeyeballs is right. What you need to do is key off of your Sales Reps instead of their orders or quotes. That way all of them are accounted for. If you don't find a record for a quote for a specific sales rep, you put 0 in.