Hello ,
I am facing an issue related to forecasting by using input filed.
I am using input field for forecasting purpose,depending on the input values provided in the forecast table for joiner HC and Joiner ARC,I am calculating the Joiner HC and Joiner TRC with respect to the Opening HC and Opening TRC.
But i am not able to get the correct result at the total level for the Joiner ARC and Joiner TRC.
I am performing below computation:
1)Joiner HC= Opening HC * Joiner HC %(Provided in the forecast Table)
2)Joiner TRC=OpeningARC *(1+Joiner TRC%)(Provided in the forecast Table)
3)Joiner ARC= Joiner TRC/Joiner HC
Issue:
Joiner HC is giving - (NULL) if we are using expression total and provide correct result with the sum of rows but we require the expression total result to be correct as it is used in the computation of Joiner ARC.
Joiner TRC is giving - (NULL) if we are using expression total and provide correct result with the sum of rows but we require the expression total result to be correct as it is used in the computation of Joiner ARC.
Joiner ARC is giving - (NULL) if we are using expression total .
I am attaching the sample application with the expected result in the xls file.
Regards,
Shailja
