Sharepoint 2016 Server - Format for refiners with calculted columns

Contributor

Hi, 

I need to use refiners in a results page for a Calculated Column.

I have a problem with the values format.

My list is the next one:

field-values.PNG

Where poc2FechaDerogacion is a Date field and  poc2EstadoVigencia is a Calculated Column:

=SI(HOY()>poc2FechaDerogacion;"No Vigente";"Vigente")

My problem is the format marked in yellow: 

 

buscador.PNG

 

How can I avoid the "string;#" text in my results? I was waiting for 2 values, "No Vigente" and "Vigente" (the same values shown in my list)

 

Regards,

María Pedreira

 

 

 

0 Replies