How is the ISA logic calculated for the Colombia, Philippines and Thailand subsidiary?

Colombia, Philippines and Thailand operates two warehouses that cover the entire country, functioning in a complementary manner. Therefore, instead of calculating the In Stock Availability (ISA) metric by averaging the stock availability across all warehouses in the region, the ISA for the entity is considered 100% if at least one of the two warehouses has stock.

Example:

General Subsidiary:
If Warehouse A has stock (Y) and Warehouse B does not (N), ISA is 50%.
Colombia and Philippines Subsidiary:
If Warehouse A has stock (Y) and Warehouse B does not (N), ISA is 100%.

The applied logic is as follows:

case when A.STORE_ID = '(National Code)' THEN '(Warehouse Code)' ELSE A.INVENTORY_ORG_CODE END AS INVENTORY_ORG_CODE

The path to the dashboard utilizing this metric is as follows:
D2C Dashboard > Business Overview > SKU Coverage & ISA > Inventory Overview