Final Amount( After multiplying)

[SH_94]

Hi Community,

May i know how can i fix the red triangle error as shown below ? Will there be any impact if we didn't change it? As i already put the field type as double as per screenshot below.

[AngelosPachis · Accepted solution]

Hi @SH_94 ,

This is just to notify you that there are more digits than currently displayed in your results pane. A double data type has 15 digits of precision, so that means 15 decimals, but not all of them are displayed there, hence the red triangle.

It's good to have it there but you can ignore it. An alternative would be to round up your figures to make that go away.You can round using the round function, so

ROUND([Yourfieldhere],0.01)

will round to 2 decimals.

ROUND([Yourfieldhere],0.001)

will round to 3 decimals and so on.

Hope that helps,

Angelos