Token: Aggregations, Count and Sum

By

Because you always need to provide summary information within websites, grids and other interfaces, it become apparent that it would be far easier to control the tallies within the rendered UI rather than provide additional complex query joins to support them. The concept provided by OWS is quite simple, it can SUM or COUNT values contained within records in your query, and provide a means of pulling the current tally at any time in the interface, either at grouping levels or within your global footer.

Aggregation Syntax

All aggregation tags contain the same logical structure. One tag, the physical SUM or COUNT tag provides a way to tally your values without physically rendering any actual output. The second, a simple Variable to poll to grab the total, uses an Action variable tag, pulling from the Action collection.

SUM Syntax:
{Sum,VariableName,Value}

COUNT Syntax:
{Count,VariableName,Value}


Example

(Detail)

<span>[Dollars]{SUM,totalDollars,[Dollars]}{COUNT,totalisActive,[isActive]}</span> 

(Group Footer)

<span>[totalDollars,Action] [totalisActive,Action]</span>
Average ( Ratings):
 
Want to help out?
 
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share