Create min/max range based on value at group level

[waikeana]

My report looks like the information below. It is displayed at the group level and summed at each project.


Project Name Percentage Complete Actual Remaining Actual+
Remaining
----------------------------------------------------------------------------------
XYZ Project 50% 275 0 274
YMCA Project 100% 543 26 569
Pid Enhancement 60% 1,369 950 2,319
Implementation Plan 61% 681 432 1,113



I want a parameter created that will only show those projects that are over 1,000
The end result should be just Pid Enhancement and Implementation Plan

However, my formula is a Sum of Actual + Sum of Remaining to give me the last column.
How do I do a select of minimum to maximum based on a Sum Total?

 

[lbass]

Not sure why you need a parameter or the minimum/maximum. Go to report->edit selection formula->GROUP and enter:

sum({table.actual},{table.project}) +
sum({table.remaining},{table.project}) > 1000

-LB