Skip to main content

Formula Columns

Enterprise

Formula Columns are virtual and in-memory columns you can add to SOQL Query, which evaluates Brobench Formula and shows the result. This expression can make use of Brobench Formula Functions, and other Formula constructs to implement your business logic.

info

Keep these things in mind when you’re using Formula Columns.

  • You need to select all fields you’re using inside the expression. If you don't select, engine will treat that value as null and evaluates, which wouldn’t be want you looking for.
  • You can add any number of Formula Colums to a query
  • You can only use Formula Columns in select clause so you can’t use that in where or having or other clauses
  • You can use Formula Columns in the child query as well

Examples

SOQLDescription
select Id, CreatedDate, LastModifiedDate, {{diff_date(CreatedDate, LastModifiedDate, 'days')}}:number DateDiff from Account limit 100This is calculating the date diff between 2 date columns using diff_date function