Community Home
Search Results:
Using Formulae
... Using Formulae Workbooks reporting allows you to build a Calculated Column using formulae. The formulae are based on MySQL statements (which is simply a ...
Reporting on NULL or Blank values
If you want to identify records with blank values, you should use an OR statement because blank values can be represented in the Workbooks database in two forms: NULL, which represents the absence of a value; or ...
Using a conditional average formula
When reporting you may wish to find the average of values returned from a conditional statement. Using an Opportunity report as an example, we will try to find the average value of each User’s Opportunities current ...
Functions within IF functions
Hi, Where can I find a full list of all functions I can use within IF functions? The only example on the Knowledge Base is x LIKE y, but hopefully there are more. Can I do things like x CONTAINS y? Thanks It sounds like you've alre ...