AnsweredAssumed Answered

Difference result come out of the same formula

Question asked by clomama :D on May 28, 2015
Latest reply on May 29, 2015 by philmodjunk

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!

Outcomes