Skip to main content
Solved

Show percentage symbol in a GI

  • January 13, 2026
  • 4 replies
  • 35 views
bigred1022
Jr Varsity II
Forum|alt.badge.img

Hello everyone,

Is there any way to have the fields show the % symbol after the number in a column in a GI?

 

 

Best answer by nickcerri32

​@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.

      4 replies

      nickcerri32
      Semi-Pro II
      Forum|alt.badge.img+6
      • nickcerri32
      • Semi-Pro II
      • Answer
      • January 13, 2026

      ​@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.

      Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
        bigred1022
        Jr Varsity II
        Forum|alt.badge.img
        • bigred1022
        • Author
        • Jr Varsity II
        • January 13, 2026

        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.

          nickcerri32
          Semi-Pro II
          Forum|alt.badge.img+6
          • nickcerri32
          • Semi-Pro II
          • January 13, 2026

          ​@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.

          Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
            bigred1022
            Jr Varsity II
            Forum|alt.badge.img
            • bigred1022
            • Author
            • Jr Varsity II
            • January 14, 2026

            Thank you ​@nickcerri32 !!  Removing the Schema Field was the final step.  It’s showing a bunch of numbers after the decimal but I’m ok with that, the end users will just get used to that.  

              Terms & ConditionsCookie settingsAccessibility statement
              About Acumatica ERP system
              Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
              © 2008 — 2024  Acumatica, Inc. All rights reserved