Calculated Fields
      Back to home
      1. Knowledge Base
      2. Reporting
      3. Calculated Fields

      Logic Calculated Fields

      Logic calculated fields can be used to compare two or more values in your data source. They always return "0" or "1", depending on the logical test you submit your values to.

      The functions included in the logic category are:

      Function Name Syntax and Sample
      and: and runs two logical tests. If the logical test is true, it returns 1. If one or both are false, it returns 0. Syntax: and({logical1},{logical2})
      Sample: and([BirthDate]>date(1983, 07, 15, 04, 06, 55),[Department]="CPA")
      not: not runs a logical test. If the logical test is false, it returns 1. If the logical test is true, it returns 0. Syntax: not({logical})
      Sample: not([OfficeId]>=3)
      or: or runs two logical tests (if statements). If either one of the logical tests is true, it returns 1. If both are false, it returns 0. Syntax: or({logical1},{logical2})
      Sample: or(if([Office]="London,UK",1,0),if([BirthDate]<date(1992,09,15,4,06,55),1,0))