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:
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.