I have a dataset on number of sales done per date by sales rep in different region.
I want to calculate sales per working hours for each day achieved by sales rep depending on the number of hours they worked. The hours will be input by user (4, 6, 8 etc)
1 answer
Hi Arnab,
You can do this with a parameter. If you simply want to divide the sales by the number of hours input by a user, then create a parameter for the user input. Make it a number type (integer) and allow for any number to be input. Then create a calculated field like this:
sum([Number of Sales]) / [Hour Parameter]
Best,
Paul
