How do I add value to sub total (Aggregate) if specific condition exists?

I have a report that has sub totals and need to add a value from another column to the subtotal. I also want to compare the sub total to the column and if choose which to display; sub total or value in other column.

Any ideas?

Thanks.

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Have you considered created a derived property on the IDO?

Legacy Contributor

(correction): Have you considered creating a derived property on the IDO?

Legacy Contributor

Thanks for the reply. Yes, however seems like a lot to go through SQL wise. Curious if the form has more intelligence than just aggregate. Thanks.

Legacy Contributor

The only way I have found to do what (I think) you are asking is like J said - using a Derived field. This was the implementation I added to a derived field on an extended and replaced IDO in order to get the ARTrans sum per Invoice:

(

SELECT

(SUM((

ISNULL(art.amount, 0) +

ISNULL(art.misc_charges, 0) +

ISNULL(art.freight, 0) +

ISNULL(art.sales_tax, 0) +

ISNULL(art.sales_tax_2, 0)) *

(CASE WHEN CHARINDEX(art.Type, 'PC') > 0

THEN-1

ELSE 1

END)

)

)

FROM

artran_all art

WHERE art.type <> 'I'

AND art.apply_to_inv_num = InvNum

GROUP BY

art.apply_to_inv_num

)

Copyright © 2025 Infor. All rights reserved.