I have a column as below. I want to multiply all values together and get one value across
Yield0.900.850.710.25Yield Total_Prod0.90 0.1350.85 0.1350.71 0.1350.25 0.135
Where Total_Prod = 0.90*0.85*0.71*0.25
Running product is given by this calculation. Refer to this Link
[RP] : EXP(RUNNING_SUM(LN(SUM([Yield]))))
But In order to find the Total Product use this calculation :
To get the output like this:
Running total using Exp and Log rules explains exp and how formula works and More info on Lookup by examples the lookup is used to navigate the different results in your view.It takes parameters to give the navigational control. More Info on last Last value in your view is the final result of the calculation.