Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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])
)
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])
)
Thanks Sunny T!