Skip to Content
author's profile photo Former Member
Former Member

Variables to check char value

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2006 at 10:49 PM

    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).

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.