Problem statement: Lookup function is not present .
Workaround: I used LAC-W function and derived value .
We need to use that derived value and derived value from another field. But am facing the following error.
RTG_Look = sumOver(sum(marketvalue*rtgmapindx))/sumOver(sum(marketvalue)) – output is 6 . RTG_Look (value 6 )need to used as input and return value from another field .I am trying to create a calculated field but not supporting the nested LAC-w