2 Replies Latest reply on Jan 16, 2012 4:31 PM by AnnetteSteinberg

    Calculation field and numbers

    AnnetteSteinberg

      Title

      Calculation field and numbers

      Post

       Version 11.03 Windows

      Hello,

      I have a calc field ( unstored/number)  that gives me the difference  between the two dates.  Works fine.  Then I've created another calc field (unstored/test) that if the age (or results of the first field) is less then or greater then certain numbers it puts in another number (used eventally as a cateogory to sort from).  My problem comes with numbers greater than 100 - it only looks at the first two numbers.  What should I include in my calc below to get around this problem?  Thanks for your help.

      Case ( age of invoice  ≤ "30"; "30";
      age of invoice   ≥  "31" and age of invoice ≤ "60";"60";
      age of invoice   ≥   "61" and age of invoice ≤ "90" ;"90";
      age of invoice  ≥ "90" ; "greater than 90")