I have a report that needs to show ranges of tickets the grouping is by User, then date of service. what I need to show is the ranges of tickets turned in by each user every day. The report is complete except for the ability to display/fomat the ranges.
Method1:
I have tried creating two formula fields (columnA (TicketRangeMinimum) and columnB (Ticket Range Maximum). the issue with this is not being able to dispaly the TicketRangeMinimum to TicketRangeMaximum on the same detail line. they always alternate.
Method2:
I tried concatenating the formulas from method1. I then checked the box to 'Format with Multiple Columns'. with this method I got close to what I wanted but was able to only display two columns if I stated the detail was 3". the gap is too big when displayed on the report. If I shorten the detail the numbers look better (in terms of distance) but I then get more than two columns which screws up the range columns.
Any ideas how I can display this correctly?
here are my Formula fields:
//TicketRangeMinimum
else
else
else
0
//TicketRangeMaximum
else
else
else
0