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?!