I have a field in Account which is a Checkbox field called 'eBilling Selected'. I want to be able to report three things using the reporting type Accounts History but, I'm struggling with the final element;
- Whether of not this is checked. DONE
- Who made the change to the field. DONE
- How many of this field are checked daily. THIS IS THE ELEMENT I'M STRUGGLING WITH.
I have both the New Value and Old Value of the field but I only want to display the New Value IF it is True. Is this possible? If not, my report/chart look a little cloudy.
I have attached a screen print. For clarification, I only want to show the GREEN element of the chart and the TRUE element in the report.
12 answers
It may be worth putting a date field on the record that is populated everyytime the field is updated just for this very reason
