I have created a new object/allocation that integrates Service Desk tickets into our model and allocates the cost accordingly. I have a column in the Service Desk Tickets Master Data labeled "Ticket Counts" which basically equals 1 for each ticket. When I pull the "Ticket Count" field into my report, it works fine for the current period, however I would like to show YearToDate Ticket count in the report. Any idea how I can achieve that? I'm not looking to allocate the counts anywhere past the "Service Desk" object.
Hi Doug,
you can create a new formula column in your report:
There you can use the YearToDate function with the syntax: =YearToDate(Data Set Name.Column Name)
e.g. like this:
Hope that helps.
Regards,
thomas