Does anyone know how to use aggregate/summary field s in calcul

No I hadn't but I just did and it worked! Funny though I took a advanced
report builder class a while back and asked the instructor how to do the
same thing and was told it couldn't be done! You are my hero, Thanks a
million.

Have you selected pre-pass in the first aggregate?
-Todd C.
Have you selected pre-pass in the first aggregate?
-Todd C.

-----Original Message-----
From: Carolee Elder [mailto:celder@...]
Sent: Wednesday, June 13, 2001 1:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Does anyone know how to use aggregate/summary fields
in calculat ions?


I am try to write a report builder report that calculates the overtime hours
each day for all hours over 8, I have an if statement that is calculating
the daily OT and it works. My problem is trying to do a if statement using
the employee summary aggregate total hours field. I have an aggregate field
that totals the employees weekly hours and am trying to use it in an if
statement to calculate the over 40 but the if statement always comes up with
zero, any idea? Any help would be greatly appreciated!


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/