Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sumproduct function in Hyperion Planning ?

user7304950Oct 9 2012 — edited Oct 11 2012

Dear all,

Does anyone know if there is any function in essbase that can do the same job of "Sumproduct" in excel ? which returns sum of corressponding arrays?

Forexample, we have Account 1 and Account 2.....and I'm trying to write a rule that says (account1->jan * account2->jan)+(account1->Feb * account2->Feb)+.....etc.

In excel, it's simply done by function named sumproduct...did anyone meet a similar function in hyperion?

Thanks.

This post has been answered by Jake Turrell on Oct 9 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2012

Added on Oct 9 2012

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

7 comments

1,533 views