- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual

This shows you the differences between two versions of the page.

— |
expression function - log [2016/09/14 14:19] (current) |
||
---|---|---|---|

Line 1: | Line 1: | ||

+ | ====== Log (Expression Function) ====== | ||

+ | ===== Purpose ===== | ||

+ | The **Log** function (LOG) is used obtain the power to which the base value must be raised to produce the number provided. | ||

+ | |||

+ | {{::log_initial.png?direct&600|}} | ||

+ | |||

+ | ===== Parameters ===== | ||

+ | The **Log** function has two parameters: | ||

+ | |||

+ | ==== Number ==== | ||

+ | |||

+ | Allowed Inputs: [[Field|field]] value or a number | ||

+ | |||

+ | The first parameter of the **Log** function is the value that should result from the base being raised to the resulting power. Either use the query builder or the type a value option to enter a number. | ||

+ | |||

+ | ==== Base ==== | ||

+ | |||

+ | Allowed Inputs: [[Field|field]] value or number | ||

+ | |||

+ | The second parameter is the number that represents the base of the exponentiation either use the use the [[Query Builder]] to choose a field that contains the value or use type a value to enter a number. If no value is provided ten will be used. | ||

+ | |||

+ | |||

+ | ===== Output ===== | ||

+ | |||

+ | The output of the **LOG** function is the power to which the base value must be raised to produce the value. | ||

+ | |||

+ | ===== Example ===== | ||

+ | |||

+ | For example LOG(1000) would result in 3 and LOG(19683,3) would result in 9. |

Copyright WorkXpress, 2020