Quick question... Can anyone help with the below I...
# administration
a
Quick question... Can anyone help with the below I am trying to pull in the Absolute Value of field {customrecord.custrecord_payment_reg_delay} as {customrecord.custrecord_payment_reg_delay}?abs and it not returning the absolute value.
m
Is this formula being used in a saved search or in an advanced PDF template?
a
It is being used in a Email Template
message has been deleted
m
try ${your_field_name?abs}
a
When I try that I get this error message:
r
I assume you already verified this is a numeric field? I'd assume you'd get a type mismatch error of some sort if not, but it's possible the formula just might not work.
a
The field type is Integer Number & I dont see another appropriate option. Also thank you responding!
m
@Antonio Cardona the link of freemarker documentation https://freemarker.apache.org/docs/ref_builtins_number.html ABS is the first one, the formula seems correct.
a
Thank you both. After trying the above and still resulting in the same error I opted to create a new Custom field and set the value in a WF after user submits ABS(field). Not the cleanest but ultimately is doing the trick.