CloudExtend Analytics supports derivative formulas from NetSuite's Saved Search configuration. Below are some examples.

**Formula(Text)**

This formula is to generate a text based on the Quantity On Hand values.

โ

Field: Formula(Text)

Formula:

`CASE WHEN {inventorynumber.quantityonhand} > 19 THEN 'Highly Available' WHEN {inventorynumber.quantityonhand} > 10 THEN 'Low Stock' WHEN {inventorynumber.quantityonhand} > 0 THEN 'Limited Stock' ELSE 'Out of Stock' END`

**Result**

**Formula(Numeric)**

This sample formula is to count the number of Customers, Total # of Individuals, and Company Customers

โ**Number of Company Type Customers**

Field: Formula (Numeric)

Summary Type: Sum

Formula:` CASE WHEN {Isperson}='T' THEN 0 ELSE 1 END`

**Number of Individual Type Customers**

Field: Formula (Numeric)

Summary Type: Sum

Formula: `CASE WHEN {Isperson}='T' THEN 1 ELSE 0 END`

**Result**