Excel Product function in Tableau

I stumbled across a question on the Tableau forums asking how to write the Excel Product function in Tableau. Full credit for the answer goes to Brian Bell in the comments of this thread https://community.tableau.com/ideas/1857.

The Product formula in Tableau is:

EXP (SUM( LN ([FieldName]) ) )

Should [FieldName] be a series of financial returns this formula provides the total return:

EXP (SUM( LN (1+[FieldName]) ) ) – 1

 

For those curious about the mathematical concepts of the LN and EXP functions I found a great site explaining the concepts.

LN gives the time needed to reach the natural rate of growth.

EXP allows the calculation of what something will be worth in future based on a certain growth rate and time period.

2018-08-14T19:28:24+00:00 August 14th, 2018|Excel, Tableau|

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.