Sum = (X1 + X2 + ... + Xn), (X1 * X2 * ... * Xn) = ?

[#1]

Hello.

I'm trying to find the way to calculate the column multiplication

As I understand I need a function such as Sum but It shuld multiply operands instead of sum them.

[#2]

What about Avg(n) * Count(n)

OK, you may need to round it a bit, but it's close

John

[#3]

swuehl a écrit:

You can do it like

= Exp(Sum(Log( F1 )))

F1 being your field name

Yep, this should work.

Provided there's only positive values in your column. Otherwise, for example :

= If(Sum((F1=0))=0, Exp(Sum(Log( Fabs( F1 )))) * (1-2*Mod(Sum((F1>=0)),2)),0)

[#4]

UnF**ingBelievelable

[#5]

You said it !!!

[tresesco]

Perhaps, you would want to add a 'DISTINCT' in the expression like:

=$(=Concat( distinct F1,'*'))