Aggregate Function

Yahoo Archive
1
Thanks Sarah, worked great!!!

Jasper

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, August 06, 2003 2:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Aggregate Function


Create a calculated field that returns the value if the po is open and
returns 0 if the po is closed. Then aggregate the calculated field.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=869563347>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I have a report that list part numbers and any POs that have that part number in them. To filter out Closed PO's, I have created a Print Condition to not print the line if the PO Line is closed. I am trying to create a aggregate field that would total up the quantity of a part that is on order from different PO's. The problem is when it totals, it totals all record lines and not just the ones that have printed. I want it to total only those lines that have printed and not the ones that the Print Condition filtered out. Is this possible? What am I doing wrong?

Thanks,

Jasper



[Non-text portions of this message have been removed]
3
Create a calculated field that returns the value if the po is open and
returns 0 if the po is closed. Then aggregate the calculated field.



[Non-text portions of this message have been removed]