Advanced Sample Formula Fields

The SuiteAnalytics Workbook Formula Builder lets you to create custom formula fields using any functions in the SuiteAnalyticsWorkbookFormulaFunctions.xls spreadsheet. You can add sample formulas for any of these functions directly from the Functions subtab in the Formula Builder using the Add the example to the formula link. See the sections below for more sample formulas you can create using the available functions:

• Calculating Duration Values with TO_NUMBER and TO_NCHAR

• Combining CONCAT and other Functions to Calculate String Values

• Casting Field Values using TO_NUMBER and TO_NCHAR

• Currency Consolidation and Conversion Using Custom Formula Fields

• Conditional Evaluations Using CASE WHEN

• Calculating Amounts for Relative Date Ranges

• Calculating Specific Dates

For more sample formulas, see Search Formula Examples and Tips.

For information about using custom formula fields for currency conversion or consolidation, see Currency Conversion Using Custom Formula Fields.

Related Topics

• Formula Fields
• Creating Formula Fields in SuiteAnalytics Workbook
• Basic Sample Formula Fields

General Notices