I am attempting to create a query that will be able to calculate the average amount earned within a set amount of days.
The amount of days this average would be based on depends on what the user will enter into the parameters.
The activity_date is my field where the parameters are set, and the net_sales is the amount I will be averaging from the days chosen.
Is there a way I can create a calculated field that is based on parameter results?
Would really appreciate the help.
Thanks