AnsweredAssumed Answered

Search REcords Criteria Value of a Calculation field not working

Question asked by Dees on Jun 14, 2013
Latest reply on Jun 17, 2013 by philmodjunk

Title

Search REcords Criteria Value of a Calculation field not working

Post

      

               My Ta
Right now I have my fields set up like this:  "Total Amount", "Payment Amount", "Payment Date", "Balance Due". Preferences
§
1
2
3
4
5
6
7
8
9
0
-
=
Backspace
                     
Tab
q
w
e
r
t
y
u
i
o
p
[
]
                          
Return
                          
                     
capslock
a
s
d
f
g
h
j
k
l
;
'
\
                     
shift
`
z
x
c
v
b
n
m
,
.
/
shift
                     
                          
                         English
                               
                               
alt
alt
                     
                
               Preferences
               Preferences
§
1
2
3
4
5
6
7
8
9
0
-
=
Backspace
                     
Tab
q
w
e
r
t
y
u
i
o
p
[
]
                          
Return
                          
                     
capslock
a
s
d
f
g
h
j
k
l
;
'
\
                     
shift
`
z
x
c
v
b
n
m
,
.
/
shift
                     
                          
                         English
                               
                               
alt
alt
                     
                
               Preference

     My Table has the following fields - InvoiceId, ToTal Amount, Payment, PaymentDate,Balance. Balance is a calculation field ( ToTalAmount - Sum(Payment),

      

     I am trying to create a report that displays all those invoices where balance is >0. My Find criteria is Balance>0. However this does not give correct results - I see some records where the balance is 0, some records where the balance is -ve and some records where balance is >0.

      

     How do I fix this.

      

     Thanks

     Dee

Outcomes