If..else condition not working

[gfisch13]

Hi all - I've tried to use the following IF/Else expression but I'm getting an error.  What am I doing wrong?

if([CC_MCC_Desc] = 'Grocery_Stores_and_Supermarkets'), Sum([CC_Item_Cost]), Sum([CC_Tran_Amt])

If the condtion is true I'm taking a Sum of a field, if the condution is false I'm taking a Sum of a different field.

Appreciate any comments.  Thanks!

[sunny_talwar · Accepted solution]

You have an extra parenthesis and a missing one at the end

if([CC_MCC_Desc] = 'Grocery_Stores_and_Supermarkets'), Sum([CC_Item_Cost]), Sum([CC_Tran_Amt]))

Try this

If([CC_MCC_Desc] = 'Grocery_Stores_and_Supermarkets',
  Sum([CC_Item_Cost]),
  Sum([CC_Tran_Amt])
)

[gfisch13]

Thanks Sunny T!