Average Value

[anonymous]

I need to find the average value of five-field notes. Where is the error?

Average(SELECT(Consultores[prazo], [conteúdo], [cultura_de_ssma],[cultura_brandt]))

[Aurelien]

Hi @Francisco1988

Average(
Consultores[prazo]
+Consultores[conteúdo]
+Consultores[cultura_de_ssma]
+Consultores[cultura_brandt]
)

For reference

List expressions - AppSheet Help

AVERAGE() - AppSheet Help

Combine lists - AppSheet Help

[anonymous]

The formula has been validated. but how do I make the note field automatically receive the value of this average?

[Aurelien]

did you try a virtual column instead of a real column ?

Use virtual columns - AppSheet Help

[anonymous]

Yes, I’m using a virtual column… do I need any specific configuration?

[Aurelien]

can you share a screenshot of your tables configurations ?

[anonymous]

follow the photos

[Aurelien]

This is hugely different.

Try then:

AVERAGE(LIST([prazo], [conteúdo], [cultura_de_ssma],[cultura_brandt]))