Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Problem
 

When referring a string column in a formula, and the value of the string column is composed of numbers, starting with a '0', the value is interpreted as a number.


Consider following configuration

...
col.domainref = Domain Reference
col.domainref.type = string
...
col.genref = MRM Reference
col.genref.type = string
col.genref.formula =  {domainref}


When the content of domainref is for instance 010, the value of the genref column will be 10.  The string value 010 is interpreted as a number 10.  The column genref will therefore contain the string 10.

 

Workaround

Provide a hint to the formula parser that the dependent column value should not be interpreted as a number as follows

...
col.domainref = Domain Reference
col.domainref.type = string
...
col.genref = MRM Reference
col.genref.type = string
col.genref.formula =  "" + {domainref}



  • No labels