Null check is not working as expected

Hi Team,

I'm having an old grid layout. I'm having a field "Classification", Currently if the data is null its showing as emply(rounded below).

Now i want to put a condition, if any of the value is null/emply i should display as "None'" otherwise as it is value

existing data 

     

      Classification

         Insurance

         Banking

       Null/Empty

Expected:

       Classification

         Insurance

         Banking

         None

Using the following code

a!gridTextColumn(
                            label: "Classification",
                            field:local!gridDatasubset.columnConfigs[31].field,
                            data: if(
                              rule!APN_isEmpty(local!gridDatasubset.data.c61),
                              "None",
                              if(
                                local!gridDatasubset.totalCount = 0,
                                {},
                                local!gridDatasubset.data.c61
                              )
                            )
                            ),

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data