Calculated fields using string

Hello,
 
Thank you for reaching out to us.
 
We want to kindly explain that Flexmonster does not provide the possibility to operate with strings in calculated values.
 
Our recommendation is to preprocess the data set in the way it contains the required field by default.
 
You are welcome to contact us in case additional questions arise.
 
Regards,
Illia

Hello,
 
Thank you for your feedback.
 
We would like to explain that such limitation is exposed due to the fact that all measures placed on the grid are aggregated (if pivot form is chosen). It means both fields from your example (ARTICLE_CODE and ARTICLE_NAME) will be aggregated as well. The output of any aggregation available for the string data type is numeric. As a result, calculated values are operating with numeric data rather than strings.
 
Our team wants to ask you to provide some additional details about your use case so we could find the best workaround.
First, it would be useful to know whether the pivot form (compact, classic) or the flat form is going to be used.
If the pivot form is used, please let us know whether the created field needs to represent the hierarchy with members or the measure.
 
As for now, we assume the initial requirement is to merge two existing fields ("ARTICLE_CODE" and "ARTICLE_NAME") and display resulting members.
It is achievable through specifying one of the fields ("ARTICLE_CODE" or "ARTICLE_NAME") as a property of another and complement the member's caption with its property using the customizeCell hook.
 
Please see an example we have prepared demonstrating the described approach.
 
The following code snippet from the example demonstrates how the property type can be applied to the "ARTICLE_NAME" field:

mapping: {
  ARTICLE_CODE: {
    type: "string",
    caption: "Atrticle"
  },
  ARTICLE_NAME: {
    type: "property",
    hierarchy: "ARTICLE_CODE"
  },
  ...
}

 
The code block below is responsible for modifying the text of headers representing the article code. It complements the content of the cell with its property - article name.

flexmonster.customizeCell((cell, data) => {
	if(data.hierarchy && data.hierarchy.uniqueName == "ARTICLE_CODE" && data.type == "header")
  	cell.text += ` - ${data.member.properties['ARTICLE_NAME']}`
})

 
Detailed information about properties and API calls used in the example is available in our documentation:

• Available data types including the property data type are listed in our documentation dedicated to the mapping object.
• customizeCell API call in our documentation

 
Please let us know if it works for you.
If your use case differs from the described one, we want to ask you to provide us with a detailed description of the result you want to achieve.
 
Regards,
Illia