Dynamic AI Support Forum

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))

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