2 Replies Latest reply on Apr 2, 2018 11:41 AM by Jim Dehner

    Basic calculation help!

    Sheryl Ramos

      I feel like this should be easy, but I'm not having any luck. Here is my calculation:

       

      IF [Tow Events]>0

      AND([Miles Tw Calc] >5)

      THEN 5

      ELSE [Miles Tw Calc]

      END

       

      I want anything with tow events >0 and miles >5 to have only 5 in my column. Everything else should look at field miles tw calc. This means that I should only see 5's and numbers below 5's in this column, but it' not working?

      I appreciate any help!


      Thanks!