Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Nov 06, 2008 1:38 pm**

Is it possible to have a sum within another sum? If so what is the correct syntax? I am trying to summarize two fields and subtract them from each other:
{Sum(Sum(GroupHeader2,ViewFinancial.imfpldamt)) - (Sum(GroupHeader2,ViewFinancial.imfosamt))}

When i try to preview this, I get an error.

Posted: **Thu Nov 06, 2008 7:58 pm**

Hello,

You need use following code:

Code: Select all

{Sum(DataBandofGroupHeaderBand2, ViewFinancial.imfpldamt)) - (Sum(GroupHeader2,ViewFinancial.imfosamt))}

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Sum within a Sum

Sum within a Sum

Sum within a Sum