1 Reply Latest reply on May 29, 2015 8:17 AM by philmodjunk

    Difference result come out of the same formula

    clomama :D

      Title

      Difference result come out of the same formula

      Post

      I've got a field called "Profile", which is set up to auto-enter calculation, with the following formula:

      Case ( Case ( IsEmpty ( TotalMarks_Old ) ; TotalMarks ; TotalMarks_Old ) < NoOfQuestion + 1/5 * (NoOfQuestion * 5 - NoOfQuestion * 1) ; 1 ;  
      Case ( IsEmpty ( TotalMarks_Old ) ; TotalMarks ; TotalMarks_Old ) < Round ( NoOfQuestion + 2/5 * (NoOfQuestion * 5 - NoOfQuestion * 1) ; 0 ) ; 2 ;
      Case ( IsEmpty ( TotalMarks_Old ) ; TotalMarks ; TotalMarks_Old ) ≤ NoOfQuestion + 3/5 * (NoOfQuestion * 5 - NoOfQuestion * 1) ; 3 ;  
      Case ( IsEmpty ( TotalMarks_Old ) ; TotalMarks ; TotalMarks_Old ) ≤ NoOfQuestion + 4.1/5 * (NoOfQuestion * 5 - NoOfQuestion * 1) ; 4 ;  
      Case ( IsEmpty ( TotalMarks_Old ) ; TotalMarks ; TotalMarks_Old ) ≤ NoOfQuestion + 5/5 * (NoOfQuestion * 5 - NoOfQuestion * 1) ; 5 ; "" )

      The marking scheme is
      TotalMark     Rank
      7-12                1
      13-18              2
      19-24              3
      25-30              4
      31-35              5

      No. of Question is 7

      When a score reaches to 25, the result come out is 3 which is supposed to be 4. However, when I replaced the content of the field by choosing Records menu > Replace Field Contents with the same formula, the result was 4. Why? How can I fix it?

      Thanks for the help!