Search code examples
crystal-reportscrystal-reports-2008

Formatting decimal point in crystal reports in required format

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?

Solution

  • 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