Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Do iterators ignore blank values?
05-09-2024
05:03 AM
I have the following two measures in a report:
1. Average growth using DIVIDE and DISTINCTCOUNT
2. Average growth 2 using AVERAGEX
Average growth 2 is higher than Average growth as it is dividing the total growth by 4 instead of 5 - which makes me think that iterators (or at the very least, AVERAGEX), ignore blank values. Is this understanding correct?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2024
07:28 AM

AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2024
07:28 AM

AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
11-09-2021 01:05 AM | |||
11-27-2023 11:47 AM | |||
10-14-2024 03:28 PM | |||
08-08-2024 12:28 PM | |||
11-07-2024 10:14 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
89 | |
82 | |
53 | |
40 | |
35 |