Target per week/Month
I am trying to create a report that compares actuals to targets for sales activities. The target is a calculated field which is equal to 5 - so I just inputted 5 into that calculated filed. (Its a target of 5 per week)
I need this calculated field (Target) to change depending on the number of weeks I select. for example the default time period is This Business Week - Target = 5 but if I select last 3 weeks then the target should be 15
I am only using one date field with the operand = between. So a DateDiff Function doesn't seem to work.
I also tried adding a custom function but it doesn't work.
I am also working on another report that has a monthly target (this target field is already in the view and is not a calculated field) and I'm experiencing the same issue as above.
Is there anything I can do to get the target to work properly depending on the date range selected?