How to sum specific columns in telerik reporting

[Sharan]

Hi,

I have some columns say sales tax,amount,reimbursable(boolean flag). Now at the end I need to display the totals of amount whose reimbursable flag='True'.
for eaxample there are 10 rows out of which 5 rows have only reimbursable flag='true' then i need to display the amounts total only for those 5 rows. please help me in regarding this.

regards
sharan

[Elian]

Hello Sharan,

Yes, this is doable by nesting functions: Sum() will give you the whole sum. However if you use IIF() you can filter the data:

Sum(   IIF(Fields.Flag == True, Fields.Amount, 0)  )

this says: if the Flag is true get the value, otherwise return 0. This way, you should get the correct summing. Regards,
Elian
the Telerik team

[Steve]

Hi.

I am new to telerik reporting. I have a report like this...

Transfer ID                     FromAcct    ToAcct    Amount
         1                              123           456          20.02
         2                              123           456          40.15
In my report footer, I have a textbox in which I am setting the expression as "=Sum(Fields.Amount)" to get the total amount which is 60.17 But, instead of that I am getting 20.0240.15. Appreciate your help on this............

[Hadib Ahmabi]

Is the Amount field by any chance string?
Try the following expression instead:
"=Sum(CDbl(Fields.Amount))"
and if this works, try to figure out, why isn't your data read as numbers.