000016492 - Data from text field gets converted to numeric when using that text field in a calculation.

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000016492
Applies To5.x
IssueData from text field gets converted to numeric when using that text field in a calculation.
Take formula: IF(FIND("-",[TextValue],1)=1,"("&RIGHT([TextValue],LEN([TextValue])-1)&")",[TextValue]).
This formula will help in identifying negative values and enclose them in parenthesis () i-e if a value is -6.0%, we want it to look like (6.0%).
Value in text field is 6.0% and if you just call that field into another text field via simple calculation [TextValue], the resulting value will be '0.06' instead of '6.0%'
When text data value is ?6.0%?, the returned text data value in another calculated text field should be the same and not ?0.06?
CauseThe issue is logged for engineering review with Release Tracker(RT)# 7293978. The change in functionality is targeted for Archer 5.4 release.
Legacy Article IDa59734

Attachments

    Outcomes