Skip to main content
Answer

How to sum variable in other section

  • July 16, 2025
  • 3 replies
  • 50 views
M
Freshman I

Hi, can anyone help me ?

 

$SubDPP=Format('{0:N2}',Round( Round([ARTran.CuryUnitPrice], 2)/1.11, 2 ))

$SubTotalDPP = CDec( $SubDPP ) * [ARTran.Qty]


I created a $SubTotalDPP variable in detailSection1, and I want to sum the variables in groupFooterSection1 =Sum( $SubTotalDPP ). and then when I run the report it always gives an invalid error Invalid field name $SubTotalDPP has been specified. 

 

 

Best answer by arthia

Hi ​@mujib , Add this formula for TotalDPP =$TotalDPP + $SubTotalDPP in detail section and display this variable in footer section. As verified, issue with your variable TotalDPP

 

1 Attachments

3 replies

A
Varsity I
Forum|alt.badge.img+3
  • arthia
  • Varsity I
  • July 16, 2025

Hi ​@mujib , Add a variable and sum, Sum( $SubTotalDPP ) in  detailSection1, then display that variable in groupFooterSection1 

Chris Hackett
M
Freshman I
  • mujib
  • Author
  • Freshman I
  • July 17, 2025

Hi ​@mujib , Add a variable and sum, Sum( $SubTotalDPP ) in  detailSection1, then display that variable in groupFooterSection1 

Hi ​@arthia98 I've tried it but it still doesn't work and still gets the same error

A
Varsity I
Forum|alt.badge.img+3
  • arthia
  • Varsity I
  • Answer
  • July 17, 2025

Hi ​@mujib , Add this formula for TotalDPP =$TotalDPP + $SubTotalDPP in detail section and display this variable in footer section. As verified, issue with your variable TotalDPP

 

Chris Hackett
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