Back in late fall of 2003 my company upgraded from Monarch Version 6 to Version 7. The transition was supposed to be seamless and for all intensive purposes it was. We did run in to a few snags. For example…
I had created a .mod file in version 6 to track aging and turnaround times. The formula in the calculated field looked like this:
[font="courier"]IF(days<8,"A 0-7",IF(days<15,"B 8-14",IF(days<22,"C 15-21",IF(days<31,"D 22-30",IF(days<61,"E 31-60","F 61+")))))[/font][/quote]It worked fine in version 6. However, when I opened the same .mod using the same report in version 7, my summary looked completely different. Naturally I was a bit concerned so I called Data Watch. A very helpful Technical Support Rep. Named Rose Cavaretta helped me. After explaining to her the issue I was encountering, she responded with the following assessment in an email dated 11/10/2003:
From: Rose Cavaretta 11/10/2003 03:16 PM
To: Jeffrey Layton
Please review the attached modified model. The problem you are having is due to the null values. In your agebucket field you do not have a test for when the date is null or missing. You have nested if statements that check for several different periods then dump the rest in over 61 days. These null values do not belong in any of the previous ranges so it gets dumped in the over 61 days. I would say that version 6 did not handle this correctly but version 7 is.[/b] What I did was add another if statement to test for null, then dump the rest in over 61. Please review the attached model and let me know if you have any questions.
Datawatch Technical Support
She proposed using a formula that looked more like this:
[font="courier"] IF(days<8,"A 0-7",IF(days<15,"B 8-14",IF(days<22,"C 15-21",IF(days<31,"D 22-30",IF(days<61,"E 31-60",IF(IsNull(days), "null", "F 61+")))))) /font[/quote]Needless to say it worked and I've been using this test for when there is a null or missing value ever since,… This does not change the fact that there was indeed a, significant enough to us, difference between Version 6 and Version 7. Moreover, the difference was not understood until stumbed upon. This leads me to my main question to one and all.
Has anyone run in to anything like this after upgrading from Version 7 to Version 8?… We are looking in to upgrading to Version 8 now and I'd appreciate the opportunity to understand from those who have already upgraded to V-8,…. What, if any, challenges have you encountered as a result of the upgrade? If none, great! I'd be interested in knowing that too. Any input would be greatly appreciated.
Jeffrey M. Layton
[size="1"][ September 12, 2005, 05:07 PM: Message edited by: Jeff Layton ][/size]