Formulas

  • Resolved gpsouthey

    (@gpsouthey)


    6 years, 11 months ago

    Hi,

    Not sure I understand how to use the formulas! I have 3 scales to evaluate (red, green and purple), but the combination of them gives 13 results.
    For example the result red and green equal and second purple.
    In this case, the equal, red and green (higher score), can have a difference of maximum 3 numbers, up or down or be the same numbers! And purple has to be at least 4 numbers below red and green! How do I do this! I have tried many ways, but I am not getting anywhere!
    I hope it makes sense! Thank you!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor ustimenko

    (@ustimenko)

    6 years, 11 months ago

    @gpsouthey, by comparing, using AND/OR/>/</=.

    Describe your logic and what you already tried.

    Thread Starter gpsouthey

    (@gpsouthey)

    6 years, 11 months ago

    The test counts how many of each color the respondent said yes, there are red, green and purple. Total of 30 questions each color. The results lead to 13 different answers being a combination of the colors.
    -The highest yes count is the strongest influence
    -The second highest yes count is supporting
    -The lowest yes count is the weak link
    -But there are also the colors with less than 3 difference in number, and they are the same strength.

    So an 1st Purple, 2nd Green and 3rd Red:
    purple-analytical-thinker > green-natural-communicator AND green-natural-communicator > red-dynamic-leader
    But in this example I still need to add that each of colors are not with a difference of more than 3, up or down, what I have tried but didn’t work was:

    purple-analytical-thinker > green-natural-communicator AND green-natural-communicator > red-dynamic-leader AND green-natural-communicator NOT ( <= red-dynamic-leader +3 ) AND green-natural-communicator NOT ( => purple-analytical-thinker + 3 )

    I don’t think I know how to use the NOT() and () or a mistake when adding the numbers!

    Thank you!

    Plugin Contributor ustimenko

    (@ustimenko)

    6 years, 11 months ago

    What if all colors are same? Or two colors same and third — not?
    Why do you add this condition on +/- 3 as same?

    Actually this logic can be implemented, but it’s too complex.

    I suggest you to design your test to avoid this edge cases and complex conditions.

    Thread Starter gpsouthey

    (@gpsouthey)

    6 years, 11 months ago

    OK, thank you!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Formulas’ is closed to new replies.