0 votes
1 view
in BI by (47.2k points)

I have a column as below. I want to multiply all values together and get one value across

Yield

0.90

0.85

0.71

0.25

Yield Total_Prod

0.90   0.135

0.85   0.135

0.71   0.135

0.25   0.135

Where Total_Prod = 0.90*0.85*0.71*0.25 

1 Answer

0 votes
by (17.6k points)
  • 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 :

LOOKUP([RP],LAST())

To get the output like this:

enter image description here

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...