Print Page | Close Window

% using #s that aren't RE Fields

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17880
Printed Date: 28 Apr 2024 at 1:18am


Topic: % using #s that aren't RE Fields
Posted By: bholt
Subject: % using #s that aren't RE Fields
Date Posted: 30 Oct 2012 at 1:23pm
Hi all,
I just started using Crystal Reports - took the intro class via Blackbaud last week, and am signed up for the Intermediate class in a week or so. I learned enough in the first class to create a simple giving report for my boss, but I'm stuck on one part and I think I need to use formulas to do it (but haven't a clue how since that wasn't covered in the beginning course).

I have the giving of all constituents in this fiscal year summed on the report and that's all working fine, but I need to show that # compared to the goal we have set at our organization and I'm not sure how to set that up so that CR will calculate the % of the goal that we have received to date. The goal isn't a field in RE, so I can't use the Sum function...

Hopefully that makes sense - I can clarify more if not! Any help would be greatly appreciated!!
 
Thanks!


Replies:
Posted By: DBlank
Date Posted: 31 Oct 2012 at 3:32am
if i understand you correctly just use the static goal value typed  into a formula
sum(giving) % goal

Posted By: bholt
Date Posted: 31 Oct 2012 at 7:58am
Aaah! It worked! Thank you so much! I knew it was simple, but don't understand formulas in CR well enough yet to figure out how it should be written. Thanks again!!

Posted By: bholt
Date Posted: 31 Oct 2012 at 8:37am
Hmm ok so this works, but it only gives me the % of the entire group. Is there any way to find the % of each group/by constituent code? So I have some coded as individual and I have the sum and some coded as major donors and the sum - I want to know what the separate % of the total is for each group.

Posted By: DBlank
Date Posted: 31 Oct 2012 at 8:40am
group on consituent code and use the group totals (in the group footer or header)
sum(giving,constituent) % goal

Posted By: bholt
Date Posted: 31 Oct 2012 at 9:28am
Aah, perfecto! Thanks again!


Print Page | Close Window