--- title: Logic Calculated Fields description: 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. --- [Skip to content](https://gohub.casebook.net/knowledge/logic-calculated-fields#main-content) [More support](https://gohub.casebook.net/knowledge/kb-tickets/new) [![logo-raspberry (1)](https://gohub.casebook.net/hs-fs/hubfs/logo-raspberry%20(1).png?width=1286&height=255&name=logo-raspberry%20(1).png)](https://gohub.casebook.net/) - [Knowledge Base](https://gohub.casebook.net/knowledge) - [Video Library](https://gohub.casebook.net/video-library) - [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new) Open main navigation Close main navigation - [Knowledge Base](https://gohub.casebook.net/knowledge) - [Video Library](https://gohub.casebook.net/video-library) - [Still Need Help?](https://gohub.casebook.net/knowledge/kb-tickets/new) - [More support](https://gohub.casebook.net/knowledge/kb-tickets/new) Hi. How can we help? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://gohub.casebook.net/knowledge) 2. [Reporting](https://gohub.casebook.net/knowledge/reporting) 3. [Calculated Fields](https://gohub.casebook.net/knowledge/reporting#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\]\