Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an expression that adds Commissions when all three fees are greater than zero. Can somebody help me adjust it so that it adds Commissions when any of the three fees are greater than zero? Thanks!!
Sum({<FeeOne = {">0"},FeeTwo = {">0"},FeeThree = {">0"}>} Commissions)
In this case I think you will need the brackets:
=Sum({(<FeeOne = {">0"}>+<FeeTwo = {">0"}>+<FeeThree = {">0"}>)*<Year={"2011"}>} Commissions)