How to Display Real Value Without Decimals

Finance and Operations/AX Developer Forum
1

Hi All,

I want to display real value in form without decimals(.00)…I have one table with Real Field.

In Form I want to display Like

Value =1.5 in table->1.5 in form

Value=1.00 in table ->1 in form

Thanks in Advance…

2

in the form control there will be property. show zero - No (make it no)

3

HI,
I have tried… but not working…

4

Try by setting MinNoOfDecimals to zero on the form control.

5

Have you tried it?

6

Hi

you can create display method with string EDT in that table. And write condition in that display method based on the decimal value like this.

real amt ;
//amt = frac(12.345);
amt = frac(this.field);
if(amt > 0)
{
return strfmt("%1",this.field);
}
else
{
return strfmt("%1",real2int(this.field));
}

7

Hi ,
Tried …Still not working…

8

It is working for me, not sure if you have made the change correctly?

9

Hi,
After restaring Ax Its working perfectly…

10

Hi Kranthi,
Can you tell me how to convert all integer field’s value to real…
Table -A
Field1-Integer-10 records
Field2-Real-10 record(Copy of Field 1 But in Real)…

11

So do you want to copy the integer field value to Real field? If so just copy it.

update_recordSet A
setting Field2 = (A.Field1);