I am running into an issue. I have an object with 5 fields that are a rating scale. We have a staff member who wants to see the average rating. This object also has other fields we'd like to add to the same report.
Basically, the staff member wants to see the average rating over a set period of time. The problem is, occasionally these items will not be rated but the record would still have other fields we want to report on. If that weren't the case, I'd just exclude the records that had blank values.
Is there any workaround to calculating/summarzing the average in the report and excluding blanks (while still showing data from other fields for records that have blank values)?
Thank you!
9 Antworten
Hi Blair,
You do not need to create formula field on report.
Please create formula field on the same object which has 5 fields.
This formula field returns value 0 if , all 5 fields are blank, else it return a a value greater than 0.
Now you will use this formule field in your report to exclude 0 values.
Filter criteria would be like this
formulafield not equals to 0
NOTE : If you experience any difficulty in creating formula , let me know the type of your all 5 fields. I will guide you
Best, Rachit.
