Target per week/Month

Dylan Cooke-Tonnesen shared this question ago

In Progress

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?

Thanks

Dylan

Files:

The same question

Replies (1)

Craig Dubin ●

Hey Dylan,

Did you ever get this answered? I have a similar question.

Reply URL