I would like to have to difference format in the same column. but I don't know if this is possible.

[juangbiestro]

Hi, guys

I would like to have to difference format in the same column. but I don't know if this is possible.

what I did:Value % = if(( value  column is)<1 && (value column)>0, FORMAT ( VALUE,0.00%), VALUE)

this formula does not work.

[ankitpatira · Accepted solution]

@juangbiestro if you column type is of type 'Text' then you maybe able to have it shown differently in a single column but I would suggest you duplicate the column and then have it shown differently for both the columns.