AnsweredAssumed Answered

Calculation field and numbers

Question asked by AnnetteSteinberg on Jan 16, 2012
Latest reply on Jan 16, 2012 by 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")

Outcomes