Variables to check char value

[Former Member]

Hi,

I need to create a variable to check if the value of a char is less than or equal to the value of another char. I'm assuming this can be done by using a variable. Could anybody please let me know how to do this?

Basically, I need to create a RKF to pull records that satisfy the above said condition.

Thanks

Ritu

[Former Member]

Is this a characteristic? How do you compare for 'less', do these char have numeric values?

If yes, you can create one formula variable each, with replacement path processing type and getting the value from the corresponding char (do this in var definition). Now, you can have two calculated KF based on these two formula variables (which in turn get values from the chars).

Since this will be a formula variable/ckf, you will likely not be able to use it for RKF (you can use it in a 'condition' though).

[Former Member]

Thanks Ajay. Yes they are characteristics and are dates. I did create a CKF using two variables (with replacement path proc type) but how do I make use of this in RKF?

Regards,

Ritu

[Former Member]

It may not be doable the way you probably want.

Let us say CKF1 is for first date and CKF2 for second date. Let us say KF1 is the key figure you want to restrict for values where CKF1 > CKF2. What you can do is create another calculated KF

CKF = (CKF1 > CKF2) * KF1.

This will give values equal to KF1 where the condition is true, and zero when condition is false. So, in a way you will get your RKF.