|Issue||Data 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?
|Cause||The issue is logged for engineering review with Release Tracker(RT)# 7293978. The change in functionality is targeted for Archer 5.4 release.|
|Legacy Article ID||a59734|