Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Has anyone used @CalcMgrExcelSUMPRODUCT in business rule or member formula? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Has anyone used @CalcMgrExcelSUMPRODUCT in business rule or member formula?

Received Response
edited Aug 1, 2019 1:27PM in Planning 6 comments


We have a requirement to calculate the sum product in the formula and it should be dynamic based on the month selected by user.

Following is the syntax documented by Oracle:



Returns the sum of the products of corresponding array components


Java Class: com.hyperion.calcmgr.common.excel.cdf.ExcelMathFunctions.SUMPRODUCT(double[],double[])

CDF Spec: @CalcMgrExcelSUMPRODUCT(values1, values2)

I have applied the same in the member formula as below:


Currently I am trying to get output using the static formula but this is not giving any result in the system.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!