AnsweredAssumed Answered

Pseudo Record

Question asked by yiningw on Oct 12, 2015
Latest reply on Oct 19, 2015 by yiningw

I currently have a list of several sorted records that display how much the field is above and below a stated average. I'd like to create a dividing static box that shows what the average number is, in between the lowest "above the average" as well as the lowest "below the average". By doing so, I've been trying to create a pseudo record that'll automatically replace that field's number with the average, so it'll automatically fit between the two fields. However, that record is now included in the calculation of the average (which is a summary field). Is there a way to omit that one record from the summary, or is there a better way to go about this?

 

Thanks!

Outcomes