AnsweredAssumed Answered

Error in Specify Calculation using Let and Average

Question asked by JackHarich on Mar 26, 2015
Latest reply on Mar 27, 2015 by philmodjunk

Title

Error in Specify Calculation using Let and Average

Post

I have a schema with some tricky calculated fields and need to calculate a weighted average. For some reason the following calculation:

Let (
   TotalArgWeight = Sum ( ArgumentWeight::Amount ) ;  
   Average ( ArgumentWeight::Amount / TotalArgWeight  )  
)

results in this error message: "In the function Average, Count, Extend, GetRepetition, Max, Min, NPV, StDev, Sum, GetSummary or GetNthRecord, an expression was found where a field alone is needed."

It's a simple calc, so I'm sure I'm doing some simple wrong thing, but have been unable to pinpoint the problem. Thanks for your help on this.

 

 

Outcomes