Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

Status Declined
Created by Guest
Created on Aug 20, 2022

Allow Failed Calculations to Output a Value Rather Than 'Calc Failed'

As an AF Asset Analytics user, I would like there to be an option to output a value rather than 'Calc Failed' if an analysis fails to evaluate.  I have several aggregate analyses which are dependent on other analyses (which will occasionally fail (which I expect)). When these lower level analyses fail, I would like to have the option of setting the output of the failed analysis to 0 (or some other value), so that the higher level analysis may continue to function properly (instead of failing as well).
  • ADMIN RESPONSE
    Aug 20, 2022
    A built in bad value (calc failed) replacement would need to cover all possible use cases and would be cumbersome if different replacements are needed per analysis. As previously pointed out, our recommendation is to use the builtin BadVal() function for your needs.
  • Attach files
  • Guest
    Reply
    |
    Aug 20, 2022
    Agreed, similar to the iferror function in excel. You could nest another calculation or some value. We have many analyses like this when we are calculating efficiencies (just to give one example). If you have a zero in the denominator, it fails. This is expected sometimes, and so we end up having to determine every expected scenario that ends in calc failed and nest if functions to deal with them.
  • Brent Bregenzer
    Reply
    |
    Aug 20, 2022
    Have you tried running a BadVal check on the variable that is mapped to the output attribute? Instead of mapping the variable with the final step of the calculation (e.g., a variable named Final) to the output attribute, you could add one more variable that runs the test: If BadVal(Final) Then 0 Else Final, and map this result to the output. This is similar to wrapping a result in Excel in the IfError function.