2. PHPRunner General questions
  3. totals and varchar basic help ?
This topic is locked

totals and varchar basic help ?

 		4/11/2008 4:50:20 PM
PHPRunner General questions
B
 billr author

I would appreciate some help i have no code experience and was trying to get field to add into one field.
Creating one table

  1. I did not see a "float" option for the types when creating a field. The information will be numerical

    like 34.5 and 23 or .5 I did not look like INT or DEC would be proper so not sure.

    I build the records as varchar
  2. I would like to add the totals of the records into one record

    example

    INFO_A

    INFO_B

    INFO_C

    INFO_TOTAL would equal (sum of info a, b +c)
    Thank for the help or any examples you can provide.
A
 		alang 4/13/2008
  1. I guess you could use DOUBLE or DECIMAL for floating point numbers.
  2. One way is on the SQL tab, create a calculated field as follows:
    SELECT

    ...

    INFO_A + INFO_B + INFO_C AS INFO_TOTAL,

    ...

    FROM ...