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.

How to write the Excel Product in Tableau

The Excel Product formula in Tableau is:


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


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

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.

Leave a Comment