+Columns documentation

General discussions

Moderators: Bob Cergol, Data Access, Cintac

+Columns documentation

Postby cavillafuerte » Fri Jun 29, 2012 4:13 pm

Is there some documentation on how to use the +Column for reports? I have created simple +Columns using formulas such as fieldname*50 or fieldname1/fieldname2 etc. I would like to create a more complex formula but can't seem to figure it out. What I would like to do is take the sum values of a column and divide by the count of that column. I have tried typing in the following but it will not work:

(sum(fieldname))/(count(fieldname))
cavillafuerte
 
Posts: 32
Joined: Fri Dec 02, 2011 8:43 pm

Re: +Columns documentation

Postby Bob Cergol » Mon Jul 02, 2012 3:19 pm

Hi Carlos,

I generally use the on-screen formula editor that allows me to click on the totals to build the formula. It remembers the syntax better than I do!

I think your formula should be more something like this:
[[1st_colum_name]]/[[2nd_Column_Name@COU]]

In the full server manual from page 98 - 104 you'll find information, and you can also find more information in new "release" documents at http://www.dynamicai.com/en/support--Training/Documentation-246

You'll find this topic in the on-line "help" documentation under: Databases, Creating Data Bound Reports, +Columns.

Regards,
Bob
User avatar
Bob Cergol
Certified Dynamic AI Professional
 
Posts: 359
Joined: Fri Dec 11, 2009 5:48 pm


Return to General discussions

cron