cancel
Showing results for 
Search instead for 
Did you mean: 

Formula producing unexpectd

Former Member
0 Kudos

Hi All,

I am using a formula to subtract CKF1 from CKF2 and the result is some arbitarary number 8535. WHy is this happening? Any clues...

Thanks,

Alex.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

solved.

Former Member
0 Kudos

Hi,

Check weather the values in your CKF1 and CKF2 are correct or not.Otherwise it means there is some wrong logic written while creating your CKF1 and CKF2.

Regards

Karthik

Former Member
0 Kudos

But I get values for CKF1 & CKF2 are displaying. Obly the formula is not working... I am using simillar formula in the same query and that is working.

CKYF1 is actual and CKF2 is plan value. I am subtracting Plan - Actual in the formula which I have done for other CKF as well and they seem to be working fine.

I keep trying different things.

Thanks,

Alex.

Former Member
0 Kudos

Hi,

Check weather your plan value is generated properly or not.Check weather there are any non-cumilative kfigs involved in your calculations.Its all about the calculations.Some where its going wrong.Cross check every thing once again.

Regards

Karthik