Can anyone advise as to why the following script is not working?
EvaluationError() gives error number 8309
FMPro Advanced debugging states no error
Script works without the round:-
Nested aggregates don't play well inside the ExecuteSQL() function.
For easier editing, you may post your query as a copy from the calc dialog:
Round(AVG(Price) ,2) as RoundedPrice
The aggregate AVG is nested inside the Round function and why you got the error you did.
You may need to post-process the results with just the AVG(). What are you doing with the result of the query?
Retrieving data ...