Hello, I have an issue with the round function. We are rounding after a complex function and then taking the text value and using that to look in a list. In a few cases only, nothing is being retrieved from the list because the text value has more characters than it should. For one example, reducing the issue to the simplest single formula that gives the error, gives: TEXT(ROUND(2.509, 2))
This returns “2.5100000000000002” instead of the expected "2.51".
I can make the list contain 4 character text values like “2.510” instead of the current "2.51" and then use LEFT(above_value, 4) to get a string to check against the list but that gives the issue that sometimes the original value will have only 2 or 3 characters so there would be no match in the list. I would need to put eg “2.5, “2.50” and “2.500” in the list to be sure of a match. Or maybe concatenate “0000” to the text before the LEFT(...., 4) function.
Can anyone verify that they see the same ROUND behaviour for the above example to confirm if this is a bug. Suggestions for a work around are welcome.
This was raised by email while the community was closed to new posts for the upgrade but no reply yet. Request (#57972).
You have done the exact thing what I had done in the project.
Only thing is that for the new line item for which formula was Value(Text), I did not use the round function. I guess we use round off to limit the number of digits and if the number of digits are 0,1, or 2 it should not be a problem for us right, could you pleae give me more details on your business scenario to assist you further.
I went into blue print and then in the format i made the new line item as number format and limited the decimals to 2 as I had the number required for display purpose only.
Attaching file for your reference with sample module
even i'm facing simmilar kind of issue regarding the calculation of decimal values or summary of line items having decimal values. I think there is a bug in Anapaln regarding the calculation of decimal values, that's why round() is also not working properly.