looking for the appropriate function

[Anonymous]

Hi guys,

I am stuck a little bit.

I have to create the following function (Sum(package size*sold))/Number

So, I have loads of differenct product with different package sizes Eg:

Product	Package size	Sold
Chocolate bar	5	12
Chocolate bar	10	28
Chocolate bar	20	27
Chocolate bar	30	11
Chocolate bar	40	14

Is there a function which calculates the package size*sold for each product?

Cheers, Joe

[sunny_talwar]

This should work the way you have it

Sum([package size]*sold)

[vishsaggi]

use your formula in a pivot table with Product as dim and expr as your sum(). Are you looking for %ge by product. What is Number in your expr? You mean total sum of your Packagesize*sold? If yes may be you can use like

= Sum(PackageSize * Sold)/Sum(TOTAL PackageSize * Sold)