AVG(cOLLECT(

lisalettieri

=AVG(COLLECT({Case Consultation Tracker Range Investable Assets}, {Case Consultation Tracker Range Investable Assets}, <100000))

Above is returning a number over 100,000.

Same issue for =MEDIAN(COLLECT({Case Consultation Tracker Investable Assets}, {Case Consultation Tracker Investable Assets}, >=500000 < 1000000, {Case Consultation Tracker Submission Year}, =2024))

Returns a number below 500,000. 😓

IEPE

HOLA, PRUEBA CON:

=AVG(COLLECT({Case Consultation Tracker Range Investable Assets}, {Case Consultation Tracker Range Investable Assets},@cell <100000))

ESPERO QUE TE AYUDE.

lisalettieri

Esto es bueno:

=AVG(COLLECT({Case Consultation Tracker Range Investable Assets}, {Case Consultation Tracker Range Investable Assets}, >=500000, {Case Consultation Tracker Range Investable Assets}, <1000000, {Case Consultation Tracker Meeting Number}, =1))

Muchas gracias!