• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Subscribers 117 subscribers
  • Views 1464 views
  • Users 0 members are here
Related

Agilent Knowledge Portal

Find maintenance, best practice, and troubleshooting articles.

Agilent Knowledge Portal

Intelligent Report Summary Calculation unfunctional

Apikiat

Hello,

I have create the Peak Area of one compound as a new value and save expression as "MethylP" then I add the new column as edit formula as "Peak Area/MythylP".

So once I have done the expression creation the Summary Calculation was unfunctional, I try to add Val or CDbl in formula it still not possible to calculate summary.

I use OpenLAB EZ Chrom A.04.08.

May I have ad advice on this case.

Parents
  • +1

    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. 

Reply
  • +1

    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. 

Children
Was this helpful?
Privacy Statement
Terms of Use
Contact Us
Site Help