When I reported the truncation problem to support directly. I not only received a call directly from them indicating it was a bug, I also receive the following email reply:
From: Charles Thompson (snip)
Sent: Monday, February 03, 2003 6:38 AM
Subject: Percentages Exported to Excel
We have reproduced the issue here. At this time there is no fix. This is forwarded to be considered in a future release.
Datawatch Tech Support
[size="1"][ February 13, 2003, 04:10 PM: Message edited by: Mike Urbonas ][/size]
OK - looks like we've figured this out - the problem you noted does happen in Monarch Pro V6.01 when you want to display the Percent of Total of the special Monarch "count" value in your summary. The Percents of Total do indeed export rounded without decimal values, or the "%" character.
Now if this presents a "critical stop" level problem for you, you could rely on this "kludge" solution in the meantime:
1. Create a calculated field in your Monarch table; the formula is simply the number 1. Let's call this new column "kludge".
2. Instead of doing a Pct of Total on "count", do a Pct of Total on "kludge" column.
Here is sample output to text I created with a Monarch Summary - the first column of figures is Pct of Total on "count" (rounds to nearest whole number, and no "%" character); the 2nd column of figures is Pct of Total on "kludge" selecting 2 decimals:
PRJ100008 01/2001 33 32.53%
PRJ105003 01/2001 0 0.24%
PRJ105004 01/2001 7 6.99%
Summary 100 100.00%[/font][/quote]Charlie was right this is a bug that should be addressed in a future release. In the meantime we will add this to our Knowledge base.
Product Marketing Manager
[size="1"][ February 14, 2003, 01:25 PM: Message edited by: Mike Urbonas ][/size]
Thanks for the work-around. It worked great! It's best that I don't use the word kluge for a field name since it shows up in the heading. We don't want people to get the wrong idea!
--Gary /b[/quote]Agree that "kludge" is not the best field name for actual use
BTW, we will definitely address this issue in a future Monarch release.