IF THEN statement in C4C calculated key figure

[Former Member]

Hello,

I need to create calculated key figure in C4C with IF-THEN-ELSE statement. I know how to create this statement in BEx queries, but in C4C I am missing some operands for this formula. Is it possible to have calculated key figure with IF-THEN in C4C at all?

Looking forward for response.

Jekaterina

[Santosh_Vadicherla]

Hi Jekaterina,

SAP C4C does not Support” IF THEN statement” in creating calculated key figure but you try with below available Boolean Operators, Otherwise you can create your own custom calculated key Figure using SDK.

AND Logical AND - The result is 1 if both operand 1 and operand 2 do not equal 0. Otherwise, the result is 0. AND("KF1", "KF2")

NOT Logical NOT - The result is 1 if the operand is 0. Otherwise, the result is 0. NOT("KF1")

OR Logical OR - The result is 1 if either the operand 1 or operand 2 does not equal 0. Otherwise, the result is 0. OR("KF1", "KF2")

XOR Logical exclusive XOR - The result is 1 if either operand 1 or operand 2 (but not both) does not equal 0. Otherwise, the result is 0. XOR("KF1", "KF1")

If this answer satisfy your query, then please do not forget to click on “Accept” this answer as correct one to benefit others as well.

Thanks and Regards
Santosh

[RohiniRajanna]

Hi Santosh,

This is correct.

I do have a qstn for you...pls help me if you can

In C4C we have field called "Gross profit" enabled in opportunity. And i need to pull that field data in a custom or standard report for a particular opportunity..

Could you let me know how that can be done successfully or any other alternative solutions?