=AVG(COLLECT({Case Consultation Tracker Range Investable Assets}, {Case Consultation Tracker Range Investable Assets}, =500000 < 1000000, {Case Consultation Tracker Submission Year}, =2024)) Returns a number below 500,000. 😓

AVG(cOLLECT(

=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. 😓

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.