Follow
Calculated Columns Valueformat

The custom value is set by changing the valuefield to valueexpression and then insert the expression

Format for the column is set in the valueexpression statement. Using expressions (provided in earlier tables) statements can made to set the column’s format to display in a desired format. To ensure your format display’s correctly, modify valueformat to = HTML. Setting the value equal to the value HTML will ensure the greatest chance your format will display as intended.