Has anyone used @CalcMgrExcelSUMPRODUCT in business rule or member formula?
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.
Tagged:
0