How to have a IF Calculated field but returning text?

posted on April 9th, 2019

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

How to have a IF Calculated field but returning text?

1 answer

Please login or Register to Submit Answer