How to handle Double and Long values in Appian?

rp_balaji

A Score Level 1

over 5 years ago

Hi,

How can we handle the Long and Double values in Appian, I tried saving 2147483647 as Integer in a constant but I got stopped with an error and when I try to convert it to integer (i.e., toInteger("2147483647")) am getting unreadable output.

So what is the best way to handle Long & Double values.

Regards,

Balaji.R

Discussion posts and replies are publicly visible

Top Replies

Aditya over 5 years ago +1 verified
Certified Lead Developer

Appian does not handle Long and Double values very well. However there are few workarounds. 1. If you want the long or double values only for display purpose, like in a form or a record or a report…
rp_balaji over 5 years ago in reply to srinatha +1
A Score Level 1

Hi Srinath, Yes I agree, the workaround to handle long or double values is to define datatype as Text but in certain cases like "If you want to compare the user entered value if it is greater than …

0 jeremys
A Score Level 1
over 5 years ago

Depending on what you're using the values for, a workaround would be to just save them as text. This will allow you to view the exact value of the number.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 vetrivelk over 5 years ago

Hi Team ,
has anyone sorted this one . if so please update .

Regards,
vetri
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
+1 Aditya
Certified Lead Developer
over 5 years ago

Appian does not handle Long and Double values very well. However there are few workarounds.

1. If you want the long or double values only for display purpose, like in a form or a record or a report, keep the value in the text form.
2. If you have to do some operation on that value like addition, subtraction etc., use todecimal(). For eg. todecimal("2147483647"). It will give you an approximate answer after rounding off certain digits.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel
0 Shubham Aware
A Score Level 1
over 5 years ago

Hello,

Appian does not support long or double value only solution is to use as text.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kaushala over 5 years ago

Hi,
I was also facing the same issue and to overcome with this we used a!textfield instead of a!intergerfield.
but to restrict the user to enter only numeric values in the text field we created one more expression that removes alphabet and special characters from the value.
##ABC_Utils_RemoveAlphabetsAndSpecialCharacter
concat(
tointeger(
apply(
charat(
ri!String,
_
),
enumerate(
lenb(
ri!String
)
) + 1
)
)
)
Replace your integer field with this code
_____________________________________________________________________________________________________
a!textField(
label: "Amount",
value: rule!ABC_Utils_RemoveAlphabetsAndSpecialCharacter(
String: ri!String
),
saveInto: a!save(
ri!String,
rule!ABC_Utils_RemoveAlphabetsAndSpecialCharacter(
String: save!value
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rp_balaji
A Score Level 1
over 5 years ago in reply to Aditya

Hi Aditya,

Thanks for your response, yes am doing that (point no.2) as a workaround for now, but if in case calculations involved with Long or double values then Appian not supporting Long and Double datatypes may become overhead.

Regards,
Balaji.R
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rp_balaji
A Score Level 1
over 5 years ago in reply to Shubham Aware

Hi Shubham,

Thanks, In terms of displaying a Long or Double values we can use text but When there is calculation involved then we need to go with the workaround as mentioned in the previous comments.

Regards,
Balaji.R
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aditya
Certified Lead Developer
over 5 years ago in reply to rp_balaji

If you use todecimal(), all your long and double values will be rounded off , so you will always get an approximate answer even if your calculations are overhead.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 srinatha over 5 years ago

Hi Balaji,
I had the same issue couple of days back. I need to store 18 digit value. So it was the same "2147483647" constant that will be stored in db table. So, I changed the type of the CDT field to "Text" and make the db field value as varchar.

The reason is Appian doesn't support long or double. If you would use decimal or float it would round it off to some values.

So, at this point I would suggest to make the field as text.

Thanks
Srinath
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 yeswanththiyarir over 5 years ago

Text would be the best option
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel