Skip to Content
0
Former Member
Jan 11, 2008 at 11:45 PM

cell definition report

30 Views

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