Logical Or

[Former Member]

I am trying to filter values out of a quantity key figures. The approach that I have taken is:

1) Create a restricted key figure which will be filter one

2) Create a restricted key figure which will be filter two

3) Create a calculated key figure and placed the following which gives me 1 rather than a difference in terms of value

( 'Quantity Total Stock' * 'Filter1 Value' OR 'Quantity Total Stock' * 'Filter 2 Value' )

How can I adapt this so that it gives me the correct value rather than the logical 1? Thanks

[Former Member]

Hi,

what are the values of filter one respectively filter 2? 0 for false and 1 for true or different? If (0,1) you can just sum up to create logical or (quantity 1 * filter 1 + quantity 2 * filter 2).

Best regards,

Björn

[Former Member]

My definitions are as follows:

Filter One: Material_Type (attribute of material) exclude a set of values. The key figure is 0TOTALSTCK

Filter Two: Special_Type (attribute of material) exclude a set of values. The key figure is 0TOTALSTCK

Filter Three: What I am trying to do is say that give me the total number which consists of the set filter 1 or filter 2

[former_member188325]

Then create two RKFs restricting total stock with material type (RKF1) and special type (RKF2).

now create a formula:

(RKF1<>0)0TOTALSTCK + (RKF2<>0)0TOTALSTCK

hope i understd your requirement correctly.

[Former Member]

If you are trying to display Filter * <> 0 logic would be

((Filter1 <> 0)Filter1 + (Filter2 <>0)Filter2)

Boolean operators return 1 for true and 0 for false

[Former Member]

Thanks for that what I am trying to display is as follows:

Column 1: 0TOTALSTCK - which is the whole set

Filter 1 (not displayed) - which is a smaller set of Column 1

Filter 2 (not displayed) - which is a smaller set of Column 1

Column 2 - contains the set of records which are part of Filter 1 or Filter 2 some of the values in Filter 1 may also be in Filter 2

[former_member188325]

your requirement is not clear.can you provide an example with some Values?

Message was edited by: Murali

[Former Member]

Examples are as follows

Example 1) Total Stock is 515

Filter 1 is 512 (out of the 515, 512 meet the filter criteria

Filter 2 is 4 out of the 515, 4 meet the filter criteria

In this example I would want to display 512, 513, 514 or 515 depending on how many of subset in Filter 2 are also in Filter 1

Example 2) Total Stock is 1007

Filter 1 is 1007

Filter 2 is 523

In this example I would want to display 1007

[former_member188325]

<i>depending on how many of subset</i>

what do you mean by subset here? i am not able to visualize it.you want to display quantities or restricted values???? filter means restricted keyfigure??

[Former Member]

Hi Murali,

Please excuse the terms that you are right filter does mean a restricted key figure. Therefore

Filter1 is just the name of the Restricted Key figure and Filter2 is the name of another Restricted Key figure

I have determined a way to solve this which meant introducing a new key figure and using if then else conditions. However, I will post a seperate question on the If condition. Have awarded points

Message was edited by: Niten Shah

[former_member188325]

Hi,

i didnt get you.whats your requirement exactly?

<i>How can I adapt this so that it gives me the correct value rather than the logical 1? Thanks</i>

correct value means??