ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: chirag on September 20, 2019, 01:44:03 pm

Title: Excluding a particular summary line from grand summary
Post by: chirag on September 20, 2019, 01:44:03 pm

Hi,
I want the grand-summary line(yellow in color) to exclude the value of (+blank) row.

Now: Total(grand-summary) = 33, 998.03 including 6156.06(blank)

Requirement: Total(grand-summary) = 33,998.03 - 6156.06 = 27,841.97

Title: Re: Excluding a particular summary line from grand summary
Post by: paramvir on September 23, 2019, 11:32:05 am

you would need to use custom aggregate to exclude the blank row.

Rows information which would be required for the custom aggregate in your case is available since v6.

https://paramquery.com/pro/api#method-aggregate