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.

[sujeetsingh]

Alek ,

It seems that you want the iteratin here .

Can you give the sample of your doc.

[#3]

Hi Aleksander

you can use sum(X1 * X2 * Xn) 

the expression will perform first (X1 * X2 * Xn)  then sum the result along the dimensions

best regards

Chris

[#4]

Here is an example: I have a dataset: 1, 2, 4, 5 and I should get 1 * 2 * 4 * 5 = 40

[#5]

what do you mean by "multiply operands instead of sum them."

Can you please send us a sample file or sample data.

Thanks,

Angad

[tresesco]

I have found a work around:

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

PFA

[#7]

Hi

Please Try "fact(Max(F1))"

Kind Regards,

Footsie

[#8]

coool tresesco Loved the work around

[#9]

It's not working on "BIG" data

[swuehl · Accepted solution]

You can do it like

= Exp(Sum(Log( F1 )))

F1 being your field name