<p>Hi,</p>
<p> </p>
<p>I'm constantly running into formatting number problems in the report designer - the most likely cause is that I'm trying to use the GUI wherever I can rather than throwing in Java functions (this is not because I don't want to use them, it's because I've not used them before and putting them in the right binding or call is something I'm more likely to get wrong than right).</p>
<p> </p>
<p>I have a crosstab. I want the numerical values coming out to be truncated and suffixed.</p>
<p> </p>
<p>So, 21459882 to become 21.4M</p>
<p> </p>
<p>Suffix is easy - can be formatted in the format number pane in preferences.</p>
<p> </p>
<p>There is no method in this pane to truncate/round though.</p>
<p> </p>
<p>In the chart I have above this crosstab, number formatting through the GUI allowed you to use the 'multiplier', so I could specift 0.000001 with one decimal to get the desired result. However, for some reason this option isn't available in the preferences of the crosstab cell.</p>
<p> </p>
<p>I know this figure can be formatted somewhere...anyone?</p>
<p> </p>
<p>Thanks in advance.</p>
