4 Replies Latest reply on Jun 17, 2013 9:52 AM by philmodjunk

    Search REcords Criteria Value of a Calculation field not working

    Dees

      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

        • 1. Re: Search REcords Criteria Value of a Calculation field not working
          philmodjunk

               What hardware and software are you using to post messages to this forum? Your post includes some weird text in it and we may need to bring this to the attention of ModMan--our forum moderator so that he can contact the RightNow team over at Oracle and let them know that there's a probelm.

               

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

               Sum (Payment) in this context will return exactly the same result as just Payment and you could rewrite your calculation for balance to be:

               TotalAmount - Payment

               And get the same result.

               I'd check your result type in the Balance calcualtion. It should specify Number. If Text is selected, the calculation will appear to work, but searches and finds on this field will not.

          • 2. Re: Search REcords Criteria Value of a Calculation field not working
            Dees

                 Using mac book and safari

                  

                  

                            
                           Preferences
                            
                           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
                                 
                            
                           Preferences

                  

            • 3. Re: Search REcords Criteria Value of a Calculation field not working
              Dees

                   The Balance is a calculation field and the result is a number. However when I do the search in a list view I do not the appropriate results

                              
                             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

                    

              • 4. Re: Search REcords Criteria Value of a Calculation field not working
                philmodjunk

                     Hmm, with such a common choice of platform and browser, I'm suprised we are seeing this result in terms of the odd text that is inserted into each of your posts.

                     Please post an example of the data you have, the search criteria you are using and the results you are getting when you "do not get appropriate results".