Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a bar chart that shows total number of Sales by Sales Rep Names
I want to show total number of sales reps on the title so the users would know exactly how many sales reps are there.
I am using following expression as the title of that chart
='Total Sales by ' &count(Distinct(RepName)) &' Sales Reps'
What is the best way to write above expression to manage Singular & Plural?
Example : If there is only 1 Rep selected then the title should say 'Sales Rep' instead of 'Sales Reps'
Thank you.
Or even this
='Total Sales by ' & count(Distinct(RepName)) & 'Sales Rep' & If(Count(DISTINCT RepName) = 1, '' , 's')
May be like this:
='Total Sales by ' &count(Distinct(RepName)) & If(Count(DISTINCT RepName) = 1, ' Sales Rep', ' Sales Reps')
or just this may be
='Total Sales by ' &count(Distinct(RepName)) &' Sales Rep/s'
Or even this
='Total Sales by ' & count(Distinct(RepName)) & 'Sales Rep' & If(Count(DISTINCT RepName) = 1, '' , 's')
Thank you once again