Thanks Albert. Big learning day. Bruce Chitiea SafeSectors, Inc. 909.238.9012 cell
> -------- Original Message -------- > Subject: [RBASE-L] - Re: Fail: Computed Column Shows all Nulls (-0-) > From: Albert Berry <[email protected]> > Date: Mon, February 13, 2012 3:24 pm > To: [email protected] (RBASE-L Mailing List) > > > You need to set null on so that it computes as a zero. > Albert > > On 13/02/2012 11:19 AM, Bruce Chitiea wrote: > > All: TIA > > > > RBG91_64.EXE SU > > Build: 9.1.5.20103 > > Windows 7 Ultimate > > > > Problem: > > The null (-0-) value appears in a computed column across ALL rows in a > > browsed table, where the computed column has been added after the table > > is populated with data. > > > > Creating the computed column: > > 1. Create/insert a computed column in an existing data-populated table. > > 2. Insert the computed column below all columns used in the calculation. > > 3. All columns share the data type CURRENCY. > > 4. Simple expression: "(col1 + col2 + col3 + col4 + col5 + col6)". > > 5. There is at least one null (-0-) value in EACH row within the column > > set [col1 ... col6]. > > 6. There is no row with ALL null values in column set [col1 ... col6]. > > > > Thoughts? > > > > Bruce Chitiea > > SafeSectors, Inc. > > 909.238.9012 cell > > > > > > > > > > > > > >
