How to make a list of the values in the multiplying together

[alex_stone]

currently, we have one table as below:

BP	Day	TW
001	2017-01-01	1.0012
001	2017-01-02	2.3201
001	2017-01-03	3.1200
001	2017-01-04	4.2398
001	2017-01-05	5.1121
001	2017-01-06	6.3490
001	2017-01-07	7.8903
002	2017-01-01	0.1123

I want to multiplying the values based on selected days.

case 1 : selected 2017-01-01, 2017-01-03, 2017-01-04,  BP 001 result = 1.0012 * 3.1200 * 4.2398

                                                                                 BP 002 result = 0.1123

case 2: selected 2017-01-04， 2017-01-05， 2017-01-06， 2017-01-07 , BP 001 result = 4.2398 * 5.1121 * 6.3490 * 7.8903

in one chart, BP as dimension. how to reach above case on the expresson.

[sunny_talwar · Accepted solution]

May be this

EXP(Sum(Log(TW)))

[Anonymous]

is there  no evaluate() function in the frontend?

[sunny_talwar]

There is dollar sign expansion you can use with concat function

[sunny_talwar]

But I guess it won't evaluate on each dimension...

[Anonymous]

that's why my question

I had the idea using

evaluate(concat(total <BP>  PW,'*'))

as expession...

[sunny_talwar]

Don't think evaluate is available on the front end ... but I guess why look for an alternate when exponential and logarithmic allows us to do what is needed

[alex_stone]

Thanks Sunny & Robin, whether there is a function like Sum can multiplying a list value together?

[sunny_talwar]

Did you look at the attachment here?

Re: How to make a list of the values in the multiplying together

[alex_stone]

Thanks a million!　Ｉ　ｈａｖｅ　ｆｉｘｅｄ　ｉｔ　ｂｙ　ｙｏｕｒ　ｓｏｌｕｔｉｏｎ．