2 Replies Latest reply: May 17, 2016 9:21 AM by Stefan Wühl RSS

    Need some help with Set Analysis

    Marco van Zand

      Hi All,

       

      I'm trying to create a function to calculate an average of 461nm VIS based on specific values.

       

      Rangnr is the rank per record 1,2,3 etc.

       

      2880 is an solid number but the next number 4647 is a function avg(Rangnr)

       

      avg({1<Rangnr={">2880<=4647"}>}461nmVis)

       

      4647 is a dynamic number and will change based on the amount of data