Unable to use select expert on Formula Field 2

[mtepfer]

I have a report that evaluates a change in rent from one line of data to the next and calculates the difference.

The report is grouped by a client ID and uses the following formula:

If (previous ({vwRentChanges.ContractRent}) < {vwRentChanges.ContractRent}) and ({vwRentChanges.ClientId} = previous({vwRentChanges.ClientId})) then
{vwRentChanges.ContractRent} - previous({vwRentChanges.ContractRent})
Else
0

THe output is like :

Client ID History Record Rent Change
38 1 500 0
38 2 500 0

45 1 700 0
45 2 750 50

I want to do a select expert that will show only each group (client ID) that has a change value greater than 0. FOr instance in the previous example only client 45 would appear on the report.

When I attempt a select expert the option for the change field is not showing. My best guess is that it can't because it evaulates record to record, how do I get around this. Thanks .

Also am using CR9

Mike

 

[lbass]

Insert a group on {table.clientID} and then go to report->edit selection formula->GROUP and enter:

maximum({table.rent},{table.clientID}) <>
minimum({table.rent},{table.clientID})

-LB