Using LTS gets you to compare each element of an array to each of another. Reuse will repeat the last element if you have an unequal number of elements in each array.
It could also be a problem that this dictionary has an "MTS" conversion. It is probably comparing a time to zero. By the way, use (ICONVS, OCONVS) on a multivalue field. Or make another dictionary without the conversion, but pointing at the same data. also look up (CATS, GES, GTS, LES, LTS, EQS, ORS, ANDS, MULS, NUMS, FMTS, LENS, and so on.) > From: damad...@comcast.net > To: u2-users@listserver.u2ug.org > Date: Tue, 7 Jul 2009 15:43:53 -0500 > Subject: Re: [U2] Calculation on multi-valued elements > > Is it because of the IF statement? @record<3>-...@record<2> tabulates > correctly > for each value position. > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey > Sent: Tuesday, July 07, 2009 3:40 PM > To: U2 Users List > Subject: Re: [U2] Calculation on multi-valued elements > > > You want to look at IFS, LTS, and REUSE... > > On Tue, Jul 7, 2009 at 1:27 PM, David Ward <damad...@comcast.net> wrote: > > > Hello all, > > > > I'm hoping this is a good place to find the error of my ways. I > > thought it was possible to do tabulations on multivalued fields within > > a dictionary item. I've included the dictionary, a sample of the > > output and a sample of the item. > > > > We've already resolved it another way, but thought this would have > > worked, but it appears to function only on the first multivalue > > > > Thanks for looking! > > > > > > RUN_TIME > > 0001 I > > 0002 IF (@RECORD<3> - @RECORD<2>) LT "0" THEN ((@RECORD<3> - > > @RECORD<2>) + > > 86400) ELSE (@RECORD<3> - @RECORD<2>) > > 0003 MTS > > 0004 Run Time > > 0005 10R > > 0006 M > > > > Listing Sample > > LIST STATS START FINISH RUN_TIME 03:03:19pm 07 J > > STATS Run Time.. > > > > 15164 02:49:58 > > -18:06:50 > > -21:09:00 > > -13:35:38 > > -13:36:53 > > -20:49:57 > > > > Item Sample > > 0002 76202²69001²76202²76202²76201²76201 > > 0003 ²3791²62²27264²27188²1204 > > > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _________________________________________________________________ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_BR_life_in_synch_062009 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
