The exception to this is in aggregations: when aggregating a category's items, none values are simply excluded from the computation. This is because it is useful to see aggregated values even if some underlying cells contain none values, as is typical in use-cases such as headcount modelling.

For example, if you're wanting to see the average bonus across your employees, but exclude from the average those employees who do not receive a bonus (and therefore are none), you would do the following to the Bonus by Employee variable:

Set empty value setting to none
Set category aggregation to average

🚨 Note that if you try to use that aggregated variable in another formula - it will be treated as none- see Troubleshooting for more.