Formula question
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19450
Printed Date: 01 May 2024 at 10:14pm
Topic: Formula question
Posted By: Capson
Subject: Formula question
Date Posted: 21 Apr 2013 at 7:43am
I have three fields called "UniqueID" "Relationship" and "Score".
Relationship:
Self
Boss
Peer
Direct Report
Other
I need to merge the Scores from "Others" and "Peer" into one group labeled "Peers" and I need to merge the "UniqueID" from "Others" and "Peer" into the "UniqueID" for "Peers"
Essentially I want to merge "others" into "Peers"
This seems like it is a easy thing to do but after 2hrs of trying I thought I would ask for help
Thanks
|
Replies:
Posted By: Sastry
Date Posted: 22 Apr 2013 at 2:31am
Hi
create a formula on Relationship field to group on
If {Relationship} in["Others","Peer"] Then "Peer"
else
{Relationship}
Now insert a group on this formula to give you a group by mirging peer and others into one group.
-------------
Thanks,
Sastry
|
Posted By: Capson
Date Posted: 22 Apr 2013 at 6:20am
|
Thank you Sastry that gave me what I was hopping for.
|
|