## Anaplan equivalent of the "Product" Function

Previous Contributor

## Anaplan equivalent of the "Product" Function

I would like to use a formula that calculates the product of a series of items.

1 ACCEPTED SOLUTION

Accepted Solutions
Previous Contributor

## RE: Anaplan equivalent of the "Product" Function

Would creating a series of Line Items that take logarithms, perform a summation and finally take exponents suffice?
3 REPLIES 3
Previous Contributor

## RE: Anaplan equivalent of the "Product" Function

Would creating a series of Line Items that take logarithms, perform a summation and finally take exponents suffice?
Regular Contributor

## RE: Anaplan equivalent of the "Product" Function

You can do this, but you need to do it in a couple of stages. Let's say you've got a line item called Factor and you want the summary to be PRODUCT. You need to create an intermediate line item called Logarithm with the formula
`LN(Factor)`
and set its summary to Sum. Now add another line item called Product with the formula
`EXP(Logarithm)`
and set its summary to Formula. This will multiply all the values in Factor and put the result in Product. I think this is the same approach that Jack recommended.
Occasional Contributor

## Re: RE: Anaplan equivalent of the "Product" Function

This solution needs more visibility. I searched for PRODUCT function equivalents or workarounds before coming up with this solution. Came to post on the community only to find it shared here >3 years ago.