299.65 is automatically converting to 299.64.

Question

Hi, 
 Whenever I'm trying to enter 271.64 or 2**.65 where (** can be any number) it's getting converted to 2**.64 
 I'm using below expression for this: 
 a!floatingPointField( label: "Test Decimal Value", value: todecimal(fixed(trunc(ri!value, 2))), saveInto: ri!value ) 
 
 Not sure, if this is an issue from Appian. Can anyone confirm this. 
 Thanks in advance.

jamesm4933 · Answer

Fascinating bug you found there. 
 From my testing, the issue seems to be with the trunc() function, fixed() does not exhibit the same behavior. 
 I recommend reducing your expression to: fixed(ri!value, 2) 
 It is not necessary to use todecimal(), as the a!floatingPointField() performs the cast as well. 
 
 So, right now, you are truncating as a floating point number, converting to a string, and setting a fixed number of characters, then converting BACK to a floating point number, for a field than then casts to a floating point number automatically. A few more steps than necessary, I should think. 
 Take care, 
 JM

Mathieu Drouin · Answer

I agree with Chris and James 
 
 Use fixed only - trunc is not necessary. 
 Put the fixed in the saveInto rather than the value 
 You can optionally combine fixed with round (see KB article below) 
 
 I don't think the todecimal is really necessary. 
 a!floatingPointField(
 label: "Test Decimal Value",
 value: ri!value,
 saveInto: {
 a!save(
 ri!value,
 if(
 a!isNotNullOrEmpty(save!value),
 fixed(save!value, 2),
 null
 )
 )
 }
) 
 
 More info found in this KB article: https://community.appian.com/support/w/kb/707/kb-1426-unexpected-results-on-decimal-calculations-and-rounding

Harshitha Mangamuri · Answer

Hi, Please try to use this code which will give you 299.65 
 a!floatingPointField(
 label: "Test Decimal Value",
 value: todecimal(fixed(trunc(299.65, 3))),
)

Harshitha Mangamuri · Answer

Can you please try this code which will solve your issue 
 a!floatingPointField(
label: "Test Decimal Value",
value: todecimal(fixed(299.65,2))
)

299.65 is automatically converting to 299.64.

Top Replies