Skip to main content
Answer

Sales Profitability Analysis

  • May 17, 2021
  • 2 replies
  • 219 views
M
Freshman I

Hello team.

I hope everyone is well and still keeping strong.

I have a question and I hope someone can help me.

is there a way to add the following 2 totals up?

 

Best answer by Naveen Boga

Hi @mc37,

you can not add sum values directly in Generic Inqruies.

As @Vinay K  said, you need to add one more column that will display sum of (Net Sale + Cost) and add the Total Aggregation for the newly added field.

Attached sample screeshot for reference.

 

 

    2 replies

    Vinay Koppula
    Semi-Pro II
    Forum|alt.badge.img+1

    Hello @mc37, on top of my head, I can think one simple solution, you can add one more column in the GI as Total which should be a sum of NetSale and Cost. And set the Total Aggregate Function to the new Total column and you should be seeing expected result. 

    Vinay Koppula
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • May 17, 2021

    Hi @mc37,

    you can not add sum values directly in Generic Inqruies.

    As @Vinay K  said, you need to add one more column that will display sum of (Net Sale + Cost) and add the Total Aggregation for the newly added field.

    Attached sample screeshot for reference.

     

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    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