Skip to main content
Answer

Display a total on a Generic Inquiry.

  • September 12, 2023
  • 2 replies
  • 935 views

Forum|alt.badge.img

Is it possible to add a total (Summary) at the Bottom or the Top of a Generic Inquiry in an area as highlighted on the screen shot below.   We want to get a Total for all the orders in the list.

 

Best answer by meganfriesen37

If you edit the generic inquiry, you can get the total at the Bottom Only.

Under the “Total Aggregate Function” column select the “Sum” option.
 

 

Then, at the bottom of your GI, you’ll get the total based on your current filter criteria.
 

 

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • September 12, 2023

@sspencer Yes, we can show the Totals of each column-wise at bottom using the Total Aggregate function in generic inquiry. 

 

Please find the screenshots for your reference.

 


meganfriesen37
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Answer
  • September 12, 2023

If you edit the generic inquiry, you can get the total at the Bottom Only.

Under the “Total Aggregate Function” column select the “Sum” option.
 

 

Then, at the bottom of your GI, you’ll get the total based on your current filter criteria.