Knowledge Base

Welcome to The Carlisle Group's Knowledge Base.

Search or Ask a Question

This is a keyword search that looks for matching articles that contain one or more words specifically by a user in articles’ tags, title and content. Admin writes brief intro content here via admin end. If you are unable to find an answer to your issue, please submit an issue here.

Search the Knowledge Base

Back to Articles List

Using CAS expressions across multiple columns | CAS

Added: 06/23/2016; Last Modified: 06/23/2016; Visits:1,638

 CAS Summary functions generally summarize a field (Column).total CURBAL sums the Current Balance field and high CURBAL returns the highest Current Balance.

Sometimes you will need to run summary expressions across multiple columns. The across function is used run a summary function across several columns. 

This example returns the highest value across several columns:

 

This example returns the total across multiple columns:

Keywords: across row rows