Compute (sum of datagrid column) for a calculated field ???

[dbuchanan]

Hello,

Is there a way to compute the sum of a calculated field in a datagrid?

What makes this situation particularly challenging is that the
caluclated field is a complicated expression that depends on muliple
fields and conditionals. The fact just mentioned makes in impossible to
sum the separate fields and then perform the calculattion on those
sums.

Has anyone done this before? Are there any suggestions?

Thank you,
dbuchanan

 

[samldanach]

Do you have any way of adding the formula to the data source, rather
than computing it in the grid? E.g., make it part of the SQL
statement, calculated on the server side. Then, you're just bringing
numbers into the grid, and can manipulate them (including summing)
normally. That would certainly be the simplest solution.