Hi Guru's
I have A,B,C,D Characterstics and W, X,Y,Z KeyFigure's and Calculated KF's. I want to force a negative value for a combination of D and Z, But Z is already having formula 'ACT YTD' / 'PLAN YTD' * 100.
where ACT YTD and PLAN YTD ( Calculated KF's) are once again having formulas selected from KF's.
Aalready I have tried with cell definition by selecting new formula {( 'ACT YTD' / 'PLAN YTD' * 100) * (-1)}for the combination D and Z. But when I execute, it throughs error by saying formal error in formula , then i went back and checked the formula , It has changed to (/ * 100 * - 1).
Can any one solve this issue.
Thanks in Advance
Kiran