Multiplying the below values by product function and expecting to return output as 16956.0843 but it is returning the output as 16956.08.
product(16746.75 * 1.0125)
Discussion posts and replies are publicly visible
Sandeep said:product(16746.75 * 1.0125)
this is already incorrect. you don't put the multiplication inside the product() function; you should be using either the multiplication operator "*" or the product() function on the same numbers.
One thing that's difficult to understand about Appian is that it auto-formats outputs to a user-facing plaintext value no matter what the actual result of the operation is (which is something some of us have a lot of qualms about, but that's another story). Similar to any displayed result being automatically wrapped in round(X, 2) or similar. In your case I suspect it's a matter of forcing the output to display the full decimal value, like with the function fixed()...
The regular expression I've been using can take a value like
That it shouldn't take. Then I tried changing the regular expression to
Then it began to accept values such as
I need help writing a regular expression that will work with values such as
sneaky... but what's the point?
© 2023 Appian. All rights reserved.