Crystal Reports Formula fields

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Formula fields

Author	Message
adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Topic: Formula fields Posted: 14 Dec 2010 at 5:27am
	Hi, Is it possible to add formula fields together then divide them to provide an average? I have coloumns @Turnoveryear1 @Turnoveryear2 @Turnoveryear3 I would like to get the average. thanks
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 14 Dec 2010 at 9:18am
	Sure, if they return numbers. (@Turnoveryear1 + @Turnoveryear2 + @Turnoveryear3) / 3 should work. But the word "column" there concerns me. Hopefully it's just a typo? Edited by Keikoku - 14 Dec 2010 at 9:20am
	IP Logged

adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Posted: 14 Dec 2010 at 10:27pm
	Thanks, worked like a treat. Is it possible to then use the @average column as a parameter field to only filter out average turnover that is greater than a desired value, for example £200,000 Thanks Edited by adders - 14 Dec 2010 at 10:29pm
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 15 Dec 2010 at 3:21am
	You can write a suppression formula or specify the record selection. Though I think suppression only hides records.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.