Intelligent Report Summary Calculation unfunctional

Hello,

I updated the tags on this post to increase visibility. 

This is normal behavior to see when working with Intelligent Reports and expressions containing variables. Summary calculations can only be performed on numeric values and variables/aggregators can confuse the IR Engine. Using the val() or FormatNumber() functions can sometimes get you around this, but it is not guaranteed. If you check the value format properties of the column, is the value formatted as a numeric? If not, try changing it and then click on Apply and OK. Then go back into the column properties and try setup summary calculations. This might work, but be warned that the next time you edit the column properties the value format might revert back to default and you will run into this problem again. 

To get around this you can save the column's value as an aggregator and then add text field below the table to report the summary calculation results using that aggregator. 

Hi Apikiat

I would go with the last suggestion that ryoboyle makes and save the calculated value as an aggregator variable and then get the summary calculations in text fields below the table.

/Andy

I marked this post as a Verified Answer. If you still need help, please let us know and we would be happy to continue working with you.

Dear hompooth,can you tell me, how you made the formula the Peak Area of one compound as a new value and save expression as "MethylP"? I need syntax of this formula.

Hi KolyanPauk,

I use " Save Expression Result As " function on column property as below.