Dear BW people,
I encounter a problem on using ABS() in the result row.
Suppose we have
- a calculated key figure: ADD = ABS( NODIM( 'TotFcstVarDel' ))
- a calculated key figure: DelQty = NODIM ( 'Total Forecast' ) - NODIM ( 'TotFcstVarDel' )
- a calculated key figure: FAD = 1 - NDIV0 ( 'ADD' % NODIM ( 'DelQty' ) )
'TotFcstVarDel' and 'Total Forecast' are key figures in the InfoCube.
When we want to calcultate FAD, there seems to be a problem for the result row.
For example:
Prod ADD DelQty FAD TotFcstVarDel A 4 10 60% 4 B 2 7 71% -2 C 1 9 89% 1 --------------------------------------------- R 7 26 88% 3
The results for FAD are correct in the rows, while the FAD result should be 73% instead of 88%.
(The system takes the sum of the TotFcstVarDel and not of the ADD )
This means it does not care about the ABS() function in the intermediate calculation of ADD for the intermediate result of FAD.
(so in fact it is using TotFcstVarDel instead of ADD since only ABS is the difference between TotFcstVarDel and ADD)
Has anybody encountered the same problem yet?
Can I force the system to calculate FAD result by means of the preceding result cells of ADD and DelQty instead of recalculating first the totals of ADD and DelQty in the formula?
(in other words: using values 26 and 7 directly by references or something instead of intermediate calculations)
We spent several hours on this single issue, so it would be an enourmous help if somebody had a suggestion.
Thank you very much in advance!
Best regards,
Bart