Hi All,
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)
Regards,Sandeep
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()...
fixed( product(16746.75, 1.0125), 4 )
The regular expression I've been using can take a value like
44.aaaa
That it shouldn't take. Then I tried changing the regular expression to
/\d*\.\d{1,4}/
Then it began to accept values such as
44.1aaa
I need help writing a regular expression that will work with values such as
4.1 421.11 467.111 438904.1111 0.1
But not
Sonic exe
1234.a 489.a 435.aaa 412.1a
sneaky... but what's the point?