AnsweredAssumed Answered

Calculate Average for a Period of Time

Question asked by jose_rivera on Apr 5, 2019
Latest reply on Apr 9, 2019 by yyang


I need to create some KPIs that requires the calculation of average values for various points for a specified period of time (ie. Average of same month as actual but last year). Unfortunately AF is not available (due to validation issues in GMP facility). What other options is available to calculate the average for a specified period of time, store the average and use the result in a formula (ie. (Actual Value)/(Average of Month last Year)). Thanks in advance!