cancel
Showing results for 
Search instead for 
Did you mean: 

"Or" Condition

Former Member
0 Kudos

Gurus,

I have two variables in my report, right now when user

enters values in those variables, data is pulled this

way Variable1 = "01/2004" AND Variable2 = "02/2005".

Is there a way to pull data as Variable1 = "01/2004" OR

Variable2 = "02/2005"...

Please suggest...

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

One workaround would be to -

Instead of using filters (or restrictions on char) use condition.

Create one RKF (on any KF, doesn't matter) that will return non-zero values for restriction on first var/char. Similarly a second RKF for second var/char.

Now create a CKF which is = (RKF1==0) + (RKF2==0). This will have a non-zero value for the condition you mention (OR) and zero for all others. Create a condition on this KF to show only non-zero values. Hide the CKF/RKF you don't want to see.