Total in a report only for numeric data (1 Viewer)

[Ramnik]

Hello everyone,
i have a report in which a column is there which contains numeric as well text data .. i just want to add only numeric data from that column .... what expression do i need for this ??? i want to define a function in data field of a control which shows the sum .... thankssssss

 

[bob fitz]

Try:
=Sum(IIf(IsNumeric([YourColumn]),[YourColumn],0))
Change YourColumn with the name of your column.

 

[Ramnik]

Thanks a lot .. it worked