3 Replies Latest reply on Jul 14, 2015 4:21 PM by philmodjunk

# Combination Calculation Formula help...

### Title

Combination Calculation Formula help...

### Post

hi all, any ideas why this calculation is returning an empty result when on a record with all necessary "credentials" - ie. production paid by does state "Gallery" and the Production Currency is in £ and the Production Cost is a number field with a figure in? Calculation is set to number result too.... ?

If (Production Paid By = "Gallery" & Production CURRENCY = "£" ; Production Cost)

• ###### 1. Re: Combination Calculation Formula help...

If (Production Paid By = "Gallery" AND Production CURRENCY = "£" ; Production Cost)

• ###### 2. Re: Combination Calculation Formula help...

thank you. How does & differ to AND exactly?

• ###### 3. Re: Combination Calculation Formula help...

They are completely different.

& is the concatenation operator. It "Glues" two strings of text together to make one string. "ABC" & "XYZ" ----> "ABCXYZ"

AND is a logical operator. If you have two Boolean expressions such as Production Paid By = "Gallery"; Production CURRENCY = "£" , by putting "And" between them you get a result of True only if both of these expressions also return True. If either evaluates as False, your result for the entire expression also will be False.