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