1 Reply Latest reply on Sep 27, 2016 10:15 AM by Benjamin Greene

    Grouping using calculated field

    Charles Snyder

      Is there a way for me to group all of my sales info by price category? Not sure how I would write the formula.

       

      For example:

       

      IF[Price] < 1000000 THEN '<$1M'

       

      IF [Price] > 1000000 AND <= 3000000 THEN '$1M-$3M'