8 respostas
Ok, after looking at your snapshot I think you have a few of different choices (none that you were probably hoping for):
1. You could create two reports. One for Remaining Tech Days and one for Remaining Trainning Days. Then in each report you could add a filter where Tech Days > 0 and Trainning Days > 0 respectively (assuming these Days don't have any negative numbers that would cause the resulting sum to be zero).
2. If you need to have this as one report, then I think that Conditional Highlighting would be best to highlight the good data (>0 in green) and the bad data (0 in red).
To add Conditional Highlighting:
- click on the Customize button
- in the Preview bar click on the downlist for Show and choose Conditional Hightlight.....
- in the 1st --Select Field-- dropdown field choose Sum of Remaining Tech Days
- in the right most text box on this 1st row enter in the number 0
- change the middle color to be RED (this will make sure that the hightlighting is RED for any row data value of 0 or less)
- in the 2nd --Select Field-- dropdown field choose Sum of Remaining Trainning Days
- in the right most text box on this 1st row enter in the number 0
- change the middle color to be RED (this will make sure that the hightlighting is RED for any row data value of 0 or less)
- when done click on the Ok button and then Save button to save your report
- if you need to see more than the 50 rows of preview data, then click the Run Report button to run your report
3. If your report doesn't need to be in Salesforce, then export your report out to MS Excel and manipulate it there to show the report as you need it.
