Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to have a IF Calculated field but returning text?

Answered
justin.leow asked on April 9, 2019

Hi!,

Would like to ask if it is possible for us to have a IF statement calculated field that returns text? Appreciate if you can advise the correct formula if possible. 

Attachments:
Calculated fields.png

1 answer

Public
Vera Didenko Flexmonster April 9, 2019

Hello, Justin,

Thank you for your question.

The calculated field can only return values of type number.

A way to achieve the desired output is to use the customizeCell property together with the calculated field:

1) Define the calculated field:

"measures": [
{
"uniqueName": "Weight Groups",
"formula": "if( sum(\"Operations Calculated Weight\") < 50, 0, 1)",
"caption": "Weight Groups"
}
]

 
 
2) Use customizeCell property to change the “0” and “1” in the column “Weight Groups” to the desired value:

customizeCell: function(cell, data) { 
if(data.measure != null && data.measure.uniqueName === "Weight Groups"){
if(cell.text == 0){
cell.text = ">=50kg"
}else if(cell.text == 1){
cell.text = "<50kg"
}
}
}

As a result, the cells of the “Weight Groups” column will show text as desired.

We have prepared a JSFiddle example for illustration.
 
 

Please let us know if this works for you and if you have further questions.
 
 

Best Regards,
Vera

Please login or Register to Submit Answer