CKF using NODIM and Formula variable causing problem.

[Former Member]

Hi BI Gurus,

I am looking at this Calculated KF "Proj EQC moved" used in a Marketing Analysis Query. The CKF =

NODIM(system proj redemption) – NODIM(withholding amount)* NODIM(Multiple purch req)*Market Element Constant 1 Variable / NODIM(Packages per EQC).

and the other CKF(say B) =

NODIM(Syst proj redemption) – NODIM(withholding amount) * NODIM(Multiple purch req) * Market element constant 1 variable

In these "Market Element Constant 1 Variable" is a formula variable. When used in a query these CKFs return 'X' but if the same expression put into a formula, and used they return values.

Can anybody explain what is causing the problem in this?

Thanks.

Sheo

[Former Member]

Sheo,

Use the formula variable in a separate CKF and then while using it the entire formula use wwith NODIM function.

Hope it should work......

[former_member188325]

Hi,

can you check step by step (detailed level)to see where the problem occurs exactly?

i.e use only NODIM(system proj redemption) in CKF and see the result

next Market Element Constant 1 Variable / NODIM(Packages per EQC)

next NODIM(withholding amount)

next NODIM(Multiple purch req).....etc i.e individual values of each...

regards

[Former Member]

Thanks Murali, I will follow your approach and will post here.

Sheo