Subject Total on in dbase 8.0 From Rouke <moc.liamg@rekkabrg> Date Wed, 07 Oct 2020 05:31:03 -0400 Newsgroups dbase.getting-started I'm trying to do a simple Total on operation in dbase 8.0, but am not getting results I expect: On the following table: set fields to typetota = ltrim(str(year(received)))+ltrim(str(month(received)))+testtype set fields to numbers,received,testtype TYPETOTA    NUMBERS RECEIVED   TESTTYPE 2011764       1.0000     27/07/2011 64 2011964       1.0000     07/09/2011 64 2012101       1.0000     23/10/2012 1 2012101       1.0000     23/10/2012 1 2012101       1.0000     23/10/2012 1 2012101       1.0000     23/10/2012 1 2012101       1.0000     23/10/2012 1 2012101       1.0000     23/10/2012 1 20121010     1.0000     04/10/2012 10 I do: index on ltrim(str(year(received)))+ltrim(str(month(received)))+testtype tag typetota total on typetota field numbers to lbplmdl2 and get: TYPETOTA      NUMBERS RECEIVED   TESTTYPE 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / 00                  0.0000       /  / What am I doing wrong?