Calculated Key figure -- wrong Calculation

Hi all,

In my report I need to count the number of occurences by an amount threshold.

Say, Count No.of Shopping Carts <$5000 and No.of SC>$5000.

I created a CKF on the InfoProv with formula as COUNT(SC amount>$5000) and

COUNT(SC amount > $5000)

with the SC# in the row along with the Cost Center.

But I see result in detailed view as below:

CC--

---

SC#

---

SC Amt

---

<5000 --

---

>5000

456--

---

11111

---

4000

---

3 --

---

0

-

---

22222--

---

3000

---

1 --

---

0

-

---

33333--

---

5000

---

0 --

---

1

RESULT--

---

12000

---

4 --

---

1

I should see 1 under <5000 for the first SC. This affects my overall result. I see this issue only with <5000 my values with >5000 is fine. I did the same COUNT formula and also selected before aggregation.

Any help will be appreciated.

*Points will be assigned for sure*

Thanks in advance.