Closed Seddryck closed 9 months ago
It should be possible to define an aggregation product similar to sum but executing the product of all values.
product
sum
select product(Forecasted) from WindEnergy
The PRODUCT aggregation is not a standard aggregation in ANSI SQL and is not available in Microsoft SQL Server.
PRODUCT
Generally speaking, it could be implemented as the exponential of the sum of logarithms, but we need to take of the fact that 0 is producing 0.
It's a good use case to check how to apply templates in dictionaries
It should be possible to define an aggregation
product
similar tosum
but executing the product of all values.The
PRODUCT
aggregation is not a standard aggregation in ANSI SQL and is not available in Microsoft SQL Server.Generally speaking, it could be implemented as the exponential of the sum of logarithms, but we need to take of the fact that 0 is producing 0.
It's a good use case to check how to apply templates in dictionaries