Show percentage symbol in a GI

​@bigred1022 Try

CSTR([Your Value or Formula])+’ %’

You may need to divide your value by 100 to get it to display correctly depending on your formula.

Hey ​@nickcerri32 ,  modified the entry to this:  =CSTR(sum([ARTran.UsrSalespersonGPAmt]) / NullIf(sum([ARTran.CuryTranAmt]), 0)*100/100) +’ %’

But getting nothing but yellow exclamation points in the column now.  When I hover over them, it gives the following error:

“The data type that is expected for this column mismatches the data type of the following received value: 0.401129 %.”

I have attached the GI.

​@bigred1022 I’m not able to open your GI, but you should leave the schema field empty.  You’re probably trying to set the field to be a percentage, but your formula is a string.