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.