Skip to Content
0
Former Member
Sep 12, 2007 at 03:19 PM

Group Selection w/ Medians

28 Views

Post Author: jalmeida

CA Forum: Formula

I have a really strange question. I am building an exception report and I want to take the median rate for each 'type code' and compare each individual rate of that type code to it. I want to return anything that is +/- 25% of the median. For instance if the median for type code '7' is 4%. I want only type codes '7' loans to return if their rate is under 3% or over 5%. After grouping the report by type code, I went into details and entered the following function in the suppress field;

Median ({Deposit.curIntRate}, {Deposit.typeCode}) * 1.25 > {Deposit.curIntRate} or

Median ({Deposit.curIntRate}, {Deposit.typeCode}) * .75 < {Deposit.curIntRate}

After I do that, nothing returns. However, if I type just one of the conditions, details are returned. It seems to be getting hung up if there are two separate conditions attached with an or statement. I also tried setting up two separate functions one with:

Median ({Deposit.curIntRate}, {Deposit.typeCode}) * .75 < {Deposit.curIntRate}

and the other with:

Median ({Deposit.curIntRate}, {Deposit.typeCode}) * 1.25 > {Deposit.curIntRate}

However, when I go into the selection expert. Neither of these functions are available to set as "Is True."

What am I doing wrong?!