Is there a way to have a "rule" in a matrix report that compares the total value to a custom field? Ie, I have the sum of hours per project and I want the background to be red if greater than a project custom field call Budgeted Hours. I was hoping I could just go into text mode to edit, but alas not in a matrix report.
Hi Mollie,
Yes, unlike regularly grouped reports, matrix grouped reports never have allowed such textmode augmentation. I have a vague memory of kickstarting such a report out to Excel, fiddling with it (effectively in text mode), then kickstarting it back into Workfront as a hack (and wish you luck if you Go There), but instead, suggest you consider adding a second custom calculated parameter (e.g. Matrix Color) with a formula that compares the hours per project against your existing Budget Hours custom parameter, and depending on the difference, then resolves to a text field (e.g. Red if > 110%, Yellow if <=110% and >90%, Green otherwise). With "the math" done in advance in this manner in a single parameter, you can then use the Matrix Report user interface to define conditional coloring using the resulting Matrix Color values (e.g. if Red, show red background, etc)
Regards,
Doug
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.