Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
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
25
Views
6
Comments
edited Aug 1, 2019 1:27PM in Planning 6 comments

Content

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:

@CalcMgrExcelSUMPRODUCT

Purpose:

Returns the sum of the products of corresponding array components

Syntax:

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:

@CalcMgrExcelSUMPRODUCT(@XRANGE("AKPI_DayMonth"->"JAN","AKPI_DayMonth"->"DEC"),@XRANGE("AKPI_TechAvailPctPower"->"Jan","AKPI_TechAvailPctPower"->"Dec"));

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.

Register

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