Oh, and this fact too:
When you reference the master table in the formula, it always works on a full set, whether or not a filter is applied.
When you pull the same data from a view, it will only use the filtered subset.
Sorting setting doesn’t matter in either case, you need to explicitly .Sort() in your formulas:
