Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting on a formula column

Status
Not open for further replies.

jraheja

Technical User
Oct 12, 2004
176
US
I am using CR 10. One of my column is a formula calculation and the user wants data sorting on that column. Any roundabout way to achieve this??


My formula is (Sum ({@YearEntered_YTD_ Sales}, {@Merge Club})/{Sheet1_.2004 Membership}) * 100 at a group header level.
 
Hi,
One way would be to create a group using the formula, but it would have to come after the Sum is calculated.





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
How would that help??

My report displays as
50,000 (Group 1)
Club a (Group 2) - sales, Sales per 100 m (formula above)etc
Club b (Group 2) - sales, Sales per 100 m (formula above)etc

100000 Group level 1)
Club c - sales, Sales per 100 m (formula above)etc
Club d - sales, Sales per 100 m (formula above)etc

Each club can be a merge of more than one club and so is again a formula. This Group 2 is a header since we have all summations.

Can I just call a stored procedure at the formula location?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top