Error in Specify Calculation using Let and Average
I have a schema with some tricky calculated fields and need to calculate a weighted average. For some reason the following calculation:
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.