In a summarized saved search, I have a formula numeric field with AVERAGE summary type and where the formula is field A + field B + field C. It just sums the 3 values instead of averaging them. Why is that?
r
romanvita
10/12/2023, 8:57 PM
It sounds like it's pulling average sums for the three fields then adding them?
l
Luis
10/12/2023, 9:10 PM
Yeah. I was able to get the average in a messy way where summary type is SUM and the formula is (A+B+C)/3. Now I'm confused how the AVERAGE works. Looks like it averages each data field?
Luis
10/12/2023, 9:11 PM
Also, tried to enclose the formula in AVG but it didn't work either
r
romanvita
10/12/2023, 9:12 PM
I agree I think the average is per field, and I agree I'm not sure why that would work in quite that way haha.
d
David B
10/12/2023, 10:10 PM
The search adds the three fields together on every detail line of the saved search, then averages all of those detail lines into a summary line.
But the value of that field on each detail line is the same, so you're just averaging identical values
j
Jesper M
10/12/2023, 10:18 PM
Try to put SUM(field x + field y + field z) in your formula