Grouped sums subtractions

[Nik]

Hi all,

 

I’m testing telerik reporting and I’m facing the following problem in my report.  Data is grouped by a certain value, and details have grouped sums (several of them) with an expression =Sum(IIf(Fields.digits >=4, Fields.debit,0))(just the field is changed according the data column) which work fine. Now I need to compare the values and get the difference of them.

So basically,IF =Sum(IIf(Fields.digits >=4, Fields.debit,0))   >    =Sum(IIf(Fields.digits >=4, Fields.credit,0)) then ( =Sum(IIf(Fields.digits >=4, Fields.debit,0)))  -  (=Sum(IIf(Fields.digits >=4, Fields.credit,0))) and the value should be displayed into another grouped summary field , say, Balance.

I’ve tried anything I could’ve think of unfortunately without any success, so any help would be appreciated.

Thanks,

Nik

[fullstop]

I actually did this with an Expression


= IIf(Sum(IIf(Fields.digits >=4, Fields.credit,0)) > Sum(IIf(Fields.digits >=4, Fields.debit,0)),Sum(IIf(Fields.digits >=4, Fields.credit,0)) - Sum(IIf(Fields.digits >=4, Fields.debit,0)),0)

the expression is huge, but works

Nik