Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

computed field (sum) not including last value in total (im5)

2 posts in PB Infomaker Report Writer Last posting was on 1999-07-16 19:19:02.0Z
Michael Posted on 1999-07-15 05:40:58.0Z
Newsgroups: sybase.public.infomaker.general
From: "Michael" <thomastronics@smart.net.au>
Subject: computed field (sum) not including last value in total (im5)
Organization: Thomastronics
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Thu, 15 Jul 1999 01:40:58 -0400
Lines: 10
Message-ID: <348_01bece84$cb31dc40$0100a8c0@michael>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6104
Article PK: 240040

I am having trouble with the following.

in detail band - if(getrow()=last(getrow() for group 3),salesytd,0.0)
computed field called- saytd

in group 2 - sum(saytd for group 2)

the correct values are returned in the detail band but in the group band
the total is out by the last value returned in the detail band.

I am using infomaker 5


Terry Dykstra Posted on 1999-07-16 19:19:02.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: computed field (sum) not including last value in total (im5)
Date: Fri, 16 Jul 1999 13:19:02 -0600
Lines: 23
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_cnE2I#7z#GA.313@forums.sybase.com>
References: <348_01bece84$cb31dc40$0100a8c0@michael>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6094
Article PK: 240029

I have to think about this one. IM is getting confused by you mixing
results from 2 groups.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Michael wrote in message <01bece84$cb31dc40$0100a8c0@michael>...
>I am having trouble with the following.
>
>in detail band - if(getrow()=last(getrow() for group 3),salesytd,0.0)
>computed field called- saytd
>
>in group 2 - sum(saytd for group 2)
>
>the correct values are returned in the detail band but in the group band
>the total is out by the last value returned in the detail band.
>
>I am using infomaker 5
>
>
>