Skip to main content
Question

How to use more than four decimals in a formula

  • November 29, 2023
  • 8 replies
  • 138 views
A
Freshman I
Forum|alt.badge.img

I added the following formula to a GI: =[CSAnswers.Value]*[POReceiptLine.ExtCost]

The value of CSAnswers.Value for one of the records is 0.204714, and the POReceiptLine.ExtCost for that record is 11,117.76. The value I get in the cell with the formula is 2,275.805472.

The product of 0.204714*11,117.76 is 2275.96112064.

After closer examination I realized that the formula is only using the first four decimals of CSAnswers.Value. So the value in the cell with the formula is the product of 0.2047*11,117.76 which is indeed 2275.805472.

How do I get the formula to calculate the value using the additional decimals?

 

    8 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+16

    How about

    =CDec([CSAnswers.Value])*[POReceiptLine.ExtCost]

    Daryl⚡Freelance Acumatica developer (MVPx3🏆) 🛒store.deftstrokesdev.com ⏩linkedin.com/in/darylbowman
      A
      Freshman I
      Forum|alt.badge.img
      • aaronsilber
      • Author
      • Freshman I
      • November 30, 2023

      @darylbowman what does CDec do?

      I added it to my formula and now I’m getting 0.0000

       

       

        darylbowman
        Captain II
        Forum|alt.badge.img+16

        CDec converts a string to a decimal. CSAnswers.Value is a string in the database:

        How about:

        =CDec(CStr([CSAnswers.Value]))*[POReceiptLine.ExtCost]

         

        Daryl⚡Freelance Acumatica developer (MVPx3🏆) 🛒store.deftstrokesdev.com ⏩linkedin.com/in/darylbowman
          A
          Freshman I
          Forum|alt.badge.img
          • aaronsilber
          • Author
          • Freshman I
          • November 30, 2023

          @darylbowman thanks for the explanation. I tried 

          =CDec(CStr([CSAnswers.Value]))*[POReceiptLine.ExtCost]

          And I’m still getting 0.000.

           

           

            Chris Hackett
            Community Manager
            Forum|alt.badge.img
            • Chris Hackett
            • Acumatica Community Manager
            • December 20, 2023

            Hi @aaronsilber were you able to find a solution? Thank you!

            Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
              A
              Freshman I
              Forum|alt.badge.img
              • aaronsilber
              • Author
              • Freshman I
              • December 22, 2023

              Hi @Chris Hackett thanks for checking in. Unfortunately, I was not able to solve for my use case yet.

                P
                Jr Varsity III
                Forum|alt.badge.img
                • premalathan35
                • Jr Varsity III
                • February 4, 2026

                ​@aaronsilber Can you try with CDbl([CSAnswers.Value]) * [POReceiptLine.ExtCost].

                If you get still 0, then try to modify above to, CDbl(Trim([CSAnswers.Value])) * [POReceiptLine.ExtCost]

                Premalatha N
                  KrunalDoshi
                  Freshman II
                  Forum|alt.badge.img
                  • KrunalDoshi
                  • Freshman II
                  • February 11, 2026

                  Hi ​@aaronsilber,

                  Can you upload your GI XML so I can verify and suggest you the solution.

                  If you are using the Attribute then you should be able to use “Attributexxxxx” from your main DAC, where xxxxx is your attribute name. You do not have to join with CSAnswers. I have tried this in 25 R2 demo instance and it is working for me. Let me know if this helps.

                  =CDec([POReceipt.AttributeCUSTPRVAL])*[POReceiptLine.ExtCost]

                   

                  Krunal D - Acumatica Developer | www.linkedin.com/in/onlyleader | https://krunaldoshi.com/
                    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