Formatting decimal point in crystal reports in required format

user_11581765 0
Viewed 150

I have a number field in report which is having below type of values.

19707.51

9834.01

Now I need to format the above field to get the decimal place before 4 digits.

I tried giving this

mid(totext({Command_2.INVOICE_AMT},4),1,1)+'.'+ 
mid(totext({Command_2.INVOICE_AMT},4),2,length(totext({Command_2.INVOICE_AMT},4))-1)

Required output is

1.970.751,00

983.401,00

I have this format in my system,how do i edit it?

crystal-reports-2008 crystal-reports
1 Answers

Create a formula which multiplies your values by 100.

Use the Format Editor for the formula. Choose an existing format or define your own if you need to.

enter image description here

user_61011630
Related