## 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.

Formula(Numeric)

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

This another Formula(Numeric) sample is to calculate the average cost of an Item.