Conditions not working properly???

[Former Member]

Hi,

I have created a Calc KF to check whether Cost is less than zero. It provides me the desired results (case 1).

When I use this boolean value in a condition (case 2) to provide me with only values less than zero (Boolean value Condition = 1), it does not provide me the right results. The number of records having Boolean value = 1 in both cases differ.

I am not sure why this is happening. Please provide any insights.

Thanks and Regards

Andy.

[Former Member · Accepted solution]

Hi Andy,

Could you please list the characteristics you use in the query..

and what settings have you made in the condition settings..

Just trying to understand it better,since conditions are a bit confusing always..

Ashish..

[Former Member · Accepted solution]

Hi Ashish,

The Characteristic is BOH(Balance on hand) Cost and the condition is the CKF (Boolean value = 1) which is based on BOH cost to be less than zero. I have checked the Evaluate the condition diaplyed below for all charcteristics independently. I have played with single characteristics or combinations of chracteristics, but with no luck and sometimes when I Do this I get no Applicable data. Let me know if you need further information

Thanks and Regards

Andy

[Former Member · Accepted solution]

Hi Andy,

Do you have the calculated Key Figure seperately..or you have just created a formula on the fly..

Ashish

[Former Member · Accepted solution]

Hi Andy,

I would suggest you try to set the single Characteristic or combinations of characteristics. Then tick on the characteristic, which is on the most right of your drill down.

Heike

[Former Member · Accepted solution]

Hi Guys,

Thanks for your help.

Both your suggestions together worked fine for me.

Thanks and Regards

Andy