Sum within a Sum

shmuly · Post by **shmuly** » 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.

Post by **Vital** » 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.