Skip to Content
0
Former Member
Apr 16, 2014 at 02:09 PM

logic script average

76 Views

hi experts,

how to use syntax "avg" in logic script? or is there any way to implement the average calculation?

as example of data in 1 model:

emp01 entity01 interco01 percent 0.1

emp02 entity01 interco01 percent 0.2

emp03 entity01 interco01 percent 0.3

emp01 entity01 interco01 amount 1

emp02 enitty01 interco01 amount 1

emp03 entity01 interco01 amount 1

calculate average:

avg = sum(percent) / sum(amount)

avg = 0.6 / 3

avg = 0.2

thank you.