Pages:
Actions
  • #1 by betx on 15 Nov 2019
  • Hello,

    Anyone know how to block out 1m from this formula?

    IF(FIND("2m4f", "market_name") > 0, 324, IF(FIND("3m1f", "market_name") > 0, 381, IF(FIND("2m1f", "market_name") > 0, 258, IF(FIND("2m3f", "market_name") > 0, 282, IF(FIND("2m6f", "market_name") > 0, 355, IF(FIND("2m2f", "market_name") > 0, 263, IF(FIND("1m6f", "market_name") > 0, 212, IF(FIND("1m3f", "market_name") > 0, 135, IF(FIND("2m5f", "market_name") > 0, 326, IF(FIND("2m7f", "market_name") > 0, 354, IF(FIND("1m4f", "market_name") > 0, 142, IF(FIND("1m2f", "market_name") > 0, 125, IF(FIND("1m5f", "market_name") > 0, 189, IF(FIND("1m1f", "market_name") > 0, 102, IF(FIND("3m3f", "market_name") > 0, 419, IF(FIND("3m7f", "market_name") > 0, 389, IF(FIND("3m4f", "market_name") > 0, 467, IF(FIND("3m2f", "market_name") > 0, 393, IF(FIND("3m5f", "market_name") > 0, 476, IF(FIND("3m6f", "market_name") > 0, 450, IF(FIND("4m1f", "market_name") > 0, 523, IF(FIND("4m3f", "market_name") > 0, 520, IF(FIND("1m7f", "market_name") > 0, 228, IF(FIND("4m2f", "market_name") > 0, 546, IF(FIND("5f", "market_name") > 0, 55, IF(FIND("6f", "market_name") > 0, 61, IF(FIND("7f", "market_name") > 0, 79, IF(FIND("4m", "market_name") > 0, 497, IF(FIND("3m", "market_name") > 0, 360, IF(FIND("2m", "market_name") > 0, 228, IF(FIND("1m", "market_name") > 0, 91, 0)))))))))))))))))))))))))))))))

    I tried to remove it but triggers wouldn't work once I did that?

    Thank you :)
  • #2 by Oxa (WellDoneSoft) on 19 Nov 2019
  • Hello!

    The easiest way is to leave that condition intact and just add another one:

    and Market's Name does not contain " 1m"
  • #3 by betx on 03 Dec 2019
  • Tried this still not working - 


    AND(FIND("1m", "market_name_does_not_contain") > 0, 91,

    Sorry any help appreciated :)
  • #4 by armarni on 04 Dec 2019
  • Not the exact answer your looking for, but the variable market_length returns the length of a race in meters if it's available, so the condition favourites trigger expression market_length is greater than 1610 will remove races that are 1 mile or under.

    You could add it as an extra condition to your working formula, so although races containing 1 mile get through the initial formula that you've written, this new condition will then exclude them from being considered.

    If you are after an exclusion up to 2 miles, just adjust the lnumber of meters (1610 for 1 mile, 3220 for 2 miles etc)
  • #5 by betx on 04 Dec 2019
  • Thank for all your help I worked it out using conditions :)
Pages:
Actions