• Enter your formula: Enter the formula or function you want to compute.
• Return Type: This will return the format type you want in the output. E.g., if you choose percent, then the output would be 75%.
• Precision: Precision denotes the number of decimals displayed in the number field. E.g., For 345.0, if you select 1.000 then the output would be 345.000
• Enable Thousand Separator: Enable a thousand separator to your numbers. E.g., 10000 will show as 10,000 where the comma is the thousand separator.

Text Field Outcome

• Enter your formula: Enter the formula or function you want to compute.
• Format: Choose the format you want your text to be in from the drop-down menu, which includes — None(whatever you typed will be displayed without applying any format), Capitalize Each Word, lowercase, UPPERCASE and Sentence case.

Date Field Outcome

4. CONCATENATE(text1, text2,...)
5. You can join two different texts together to make them into one text value.
6.    E.g., CONCATENATE("Hi"," ", "there", "!")
7. => Hi there!
   

5. FIND(textToFind, whereToSearch,[startFromPosition])
6. This formula finds an occurrence of text inside another text.
7. textToFind: The text whose occurrence is to be found.
8. whereToSearch: The text in which the search is performed.
9. [startFromPosition]: (Optional) It starts searching from this position. Index starts from the position that you give. If not provided, it defaults to 1.

Eg., FIND("John", Supplier Name)

In the above use case, if John's name is found in the field, it gives you the position of the word.

Note: If the text occurrence is not found then the output will be 0.

2. LEN(text)
3. You can find the length of the text using this formula.

Eg., LEN(Supplier Name)

Note: If there is a space between the texts that will also be counted.

2. LOWER(text)
3. You can change the text to lowercase using this formula.

Eg., LOWER("Good morning!")

2. UPPER(text)
3. You can change the text to uppercase using this formula.

Eg., UPPER("What?")

6. MID(text, whereToStart, count)
7. You can take out a subtext within a text starting from whereToStart.
8. 
   
9. text: The text will be cut.
10. whereToStart: The starting position of the cut.
11. count: Number of characters from starting position.

Eg., MID(Supplier Name, Where to Start, Count)

7. SUBSTITUTE(whereToSearch, oldText, newText, [index])
8. You can replace a text occurrence with a new text.
9. 
   
10. whereToSearch: The text in which the search is performed.
11. oldText: The text to be searched for.
12. newText: The text to be replaced with.
13. index(optional): If the same occurrenc (text) exists more than once, you can specify which occurrence to replace. If not specified, all occurrences will be replaced.

Eg..

LOGICAL OPERATORS AND FUNCTIONS

9. AND(logical1, logical2,...)
10. If all the fields have a value in them, the formula will return a 1 since all the arguments are true; otherwise a 0. Empty field values and 0's are treated as 0(False).
11. 
    
12. Eg.,
13. AND("a", "b")
14. => 1 (True, only if both field values are true)
15. 
    
16. AND("a", "")
17. => 0 (False, when one or both field values aren't true)

In the below table, the Error Check field uses the AND formula to check if there are any empty records in the selected fields. The Error Check field returns 0 if any one of the records is empty.

6. NOT(boolean)
7. Using this function, an argument's logical meaning can be reversed.
8.     E.g., Generally, 300 > 277 would be true, but if you wrote
9. 
   
10. NOT("300 > 277")
11. => 0 (False)
    

In the above table, we use the NOT formula to find clothes that are not yellow in color.

i.e., NOT(Color="Yellow") => O when the cloth color is yellow

NOT(Color="Yellow") => 1 when the cloth color is not yellow

This helps to count the number of clothes that are not yellow in color.

2. OR(logical1, logical2,...)
3. OR() returns 1(True) if one or all field values/arguments are true. If all the values/arguments are false, it returns 0 (False).

Eg., OR(Warehouse 1,Warehouse 2)

In the above table, we use the OR formula to check if the stock is available in Warehouse 1 or Warehouse 2. If it's available even in one Warehouse, it will show the output as 1 since the stock is available.

2. XOR(logical1, logical2,...)
3. Using this function, your output returns 1 (True) if an odd number of arguments are true.

For example,

• If you are a Student, who has cleared both Unit Test 1 and Unit Test 2, then you're exempted from writing Unit Test 3.
• If you have cleared only one unit test, then you have to give Unit Test 3.
• If you have not cleared both Unit Test 1 and Unit Test 2, then you are not allowed to give Unit Test 3.
  

Now, in the above use case, you can use the XOR function for the Unit Test 3 field :

where the output would show as 1(True) if one (Odd number) field value is missing or 0(False) if both (Even number) field values are missing or available. i.e., XOR(Unit Test 1, Unit Test 2)

NUMERIC OPERATORS AND FUNCTIONS

2. ABS()
3. You get the absolute value (non-negative value without regard to its sign) as the output.

Eg., ABS(Profit)

3. AVERAGE(number1, number2,...)
4. You can find the average of the total numbers given, which is calculated by,
5. sum of the values/total number of values.

Eg., AVERAGE(Stock, Leftover Stock)

2. MAX()
3. You can find the largest number among the given numbers.

Eg., MAX({Field1}, {Field2})

MAX(24, 56)

=> 56

2. MIN(number1, number2)
3. You can find the smallest number among the given numbers.

Eg., MIN(24, 56)

=> 24

2. MOD(dividend,divisor)
3. After dividing the first input by the second, you can find the remainder as the output

Eg., MOD(Stock, Leftover Stock)

2. POWER(base, power)
3. You can find the base value for the specified power.

Eg., POWER(BASE, Power of)

2. ROUND(value,precision)
3. You can find the round-off value to the specified decimal places.

Eg., ROUND(Numbers, Precision)

2. SUM(number1, number2,...)
3. You can find the sum of the given numbers as output.

Eg., SUM(Stocks Warehouse 1, Stock Warehouse 2)

DATE AND TIME FUNCTIONS

6. DATE_ADD(date, number, 'units')
7. You can add the date units to return another date in specified units.
8. 
   
9. date: The date to which the value is added.
10. number: The number which is added.
11. units: The unit to which the number is scaled. It should be one of ["YEAR", "MONTH", "DAY", "HOUR", "MINUTE", "SECOND"].

Eg., DATE_ADD(Stock Expiry, "6", "day")

6. DATETIME_DIFF(date1, date2, 'units')
7. You can find the difference between two dates in the units that you specify.
8. 
   
9. date1: First date.
10. date2: Second date.
11. units: The unit in which the difference is returned. It should be one of ["YEAR", "MONTH", "DAY", "HOUR", "MINUTE", "SECOND"].

Eg., DATETIME_DIFF(Date of stock purchase, Stock Expiry, "day")

2. YEAR(date field)
3. You can determine a date's 4-digit year using this formula.

Eg., YEAR(Stock Expiry)

2. MONTH(date field)
3. Your output will be displayed between 1 and 12 representing only the month from the date field.

Eg., MONTH("14/09/2016 9:45")
=> 9

2. DAY(date field)
3. In this case, the output will display only the day between 1- 31 from the date field.

Eg., DAY(Stock Expiry)

2. HOUR(date time field)
3. The output will range from 0 (12:00 am) to 23 (11:00 pm), representing the time in hours.

Eg., HOUR(Field 14)

2. MINUTE()
3. The output will be between 0 to 59, representing only the minute of the time.

Eg., MINUTE(Field 14)

2. SECOND()
3. The output will be between 0 to 59, representing only the seconds of the time.

Eg., SECOND(Field 14)