Page 1 of 1

calculate the sum of a Column in a variable, not in a textfield

Posted: Mon Jun 09, 2008 7:16 am
by mabucher
Wie kann ich die Summe einer Column in einer Variablen berechnen, die ich dann in anderen Variablen weiterverwenden kann?


How can I calculate the sum of a Column in a variable (not in a textfield). This variable must make further use of variables

calculate the sum of a Column in a variable, not in a textfield

Posted: Wed Jun 11, 2008 7:04 am
by Edward
Hello,

Please use the following expression on this:

MyVariable = Totals.Sum(DataSource,expression);

Here expression can contain a column with necessary condition, e.g.:

(DataSource.DataColumn1 < somevalue)?DataSource.DataColumn2:0

Thank you.