Number Display 2

[ricolame]

Hi folks,

Would like to seek advice how i should i go about formatting my number figure so that my number can display decimal to 4 places when there is decimal figures with leading zero in front(if less than 1), and if it is not, default to whole number ?

Currently i can only default to leading zero, but if my figure is a whole number, it will show up to 4 decimal places too.

Thank you.

 

[Madawc]

Use a formula field,

 if {value} < 1 
then ToText({value}, 4)
else ToText({value}, 0)

This does not allow for negatives: they would need extra checks.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[ricolame]

hi madawc,

For ToText, there's a problem with number less than 1, it shows .xxxx, instead of 0.xxxx

Is there a way in formula to include leading 0 ?

 

[Madawc]

0" & ToText({value}, 4)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[ricolame]

hmm. stupid me. tks,

with regards,

 

[ricolame]

now, if i've to use the figure to sum for summary, i have to change it back to number =)

 

[dgillz]

Sum the original database field, not the formula field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

Instead of using a formula to convert the number to text, you could instead go to format field->number->customize->decimals->x+2 and enter:

if {table.number} = int({table.number}) then 0 else 4

You would also have rounding set to 4 decimals in the same screen.

-LB