sumproduct function in BO?

[gshadz37]

Hi,

Is there a function in BO XI similar to sumproduct in excel? I need to do a weighted average on two columns in a report. Please help.

Thanks!

 

[satinsilhouette]

I believe weighted average is available.

Thanks so much!
satinsilhouette

 

[blom0344]

AFAIK there is no array functionality in BO, but you can achieve the same result with variables..

Ties Blom

 

[xlbo]

this is what products like this were built for. In excel, SUMPRODUCT is used to replicated pivot table functionality. Pivot tables are basically built to replicate a bit of OLAP technology. BOBJ is an OLAP product ergo its native functionality should do this very easily...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question