2 Replies Latest reply on Jul 3, 2018 1:13 PM by Ray Givler

    Dash in calculation ... what does it mean?

    jon rios

      i ran across a formula

       

      SUM(IF [Benchmark / Portfolio] = True THEN [KOL 5K Pct] END)

      -

      SUM(IF [Benchmark / Portfolio] = False THEN [KOL 5K Pct] END)

       

      if i remove the dash between the formulas, there is an error... but the formula also checks for the same condition and checks for both TRUE and FALSE..

       

      what does the dash in the formula represent? why check for both TRUE and FALSE?

       

      thanks