IAC is going to return the sales aligned to a NULL branch because that is how it is reflected in the data model. The methods listed above to resolve are correct:
In the data model, replace NULL values.
In the business logic, create a synonym and only include non-NULL from your selection.
You can filter out the values by adjusting your data model to replace null values with a string value, like 'No Branch' and then ask a question like "sales branch except no branch".
If the branch fields values don't change, you can also add a synonym to the Vocabulary section that is the same name as the field and pre-select all non-null values.
IAC is going to return the sales aligned to a NULL branch because that is how it is reflected in the data model. The methods listed above to resolve are correct:
In the data model, replace NULL values.
In the business logic, create a synonym and only include non-NULL from your selection.
.png "Luminary Alumni"){kind=icon}
