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

# Dash in calculation ... what does it mean?

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

• ###### 1. Re: Dash in calculation ... what does it mean?

- is difference  between Two SUMs. The First SUM Returns SUM if Condition is TRUE and Second Returns SUM If Condition is False. So Finally it is like that

SUM(1)-SUM(2()

The Result Will  be AGG(DIFFERENCE) , an aggregate value

Hope it Helps

Thanks

Deepak

• ###### 2. Re: Dash in calculation ... what does it mean?

It's subtraction.

The sum of KOL 5K Pct where Benchmark / Portfolio is true MINUS the sum of KOL 5K Pct where Benchmark / Portfolio is FALSE.

1 of 1 people found this helpful