Expr1: (300-(sum[total purchase]))
get error: there could be an operand without operator
What am I doing wrong here?
If I go this route:
sum(300-[total purchase])
the query comes out wrong. The table is a transaction table. A customer can have more than one transaction. Problem is, with the expression above, if a specific customer has two transactions, the expression will take 300x2=600 - total purchase. 3 transactions will use 900, and so on.
I feel like the expression at the top makes more sense were it not for the error message.
I know this is probably basic stuff. Would appreciate any help. Thanks.