2 Replies Latest reply on Oct 4, 2018 5:35 PM by DanielPesch

    Process book functions

    DanielPesch

      I want to use process book and a function found in excel data link ...      =PIAdvCalcVal(Sheet6!$J$6,"t+2h","*","count","event-weighted",0,1,0,"\\Our-Pi01")

      I want to count events of a given tag.

       

      1. Is there a similar function I can use?

      2. Where can I find a listing of all the functions available to me in process book?

       

      Thank you.

      Daniel.

        • Re: Process book functions
          tramachandran

          Let me try to provide some pointers and let the PB experts chip in later.

           

          To me the simplest way to do this is to have ProcessBook point to an AF attribute or a PI Perf Equation instead of calculating this within the application.

          If you want to do this within the confines of PB, then PI ProcessBook contains Microsoft's Visual Basic for Applications (VBA) scripting support. You can use the PIExpression Dataset's Expression Property

          where the expression would be EventCount('<tag>', '<starttime>', '<endtime>')

           

          The programming guide can be accessed from PB Help menu