Expression Error in IIF statement (1 Viewer)

A

ashchak

New member
Local time
Today, 13:58
Joined
Aug 9, 2016
Messages
5
Expr1: IIf(CDate([Weekly_Upload].[Gift Date])>[Transaction_Failed].[Gift Date],"Success","Failure")

Getting error in this expression
Error : Your Query does not include specified expression as a part of aggregate function.
 
stopher

stopher

AWF VIP
Local time
Today, 21:58
Joined
Feb 1, 2006
Messages
2,395
Most likely you are trying to list this expression in your query but you haven't included it in the group by clause.

Please post the rest of your query.
 
You must log in or register to reply here.

Similar threads

B
Sum (iff) with multiple strings issue
Replies
6
Views
348
BethHawkins
B
MattBaldry
Query Error in List Box
Replies
2
Views
100
MattBaldry
MattBaldry
R
Access SQL IIf statement with GROUP BY (no alias utilized)
Replies
2
Views
444
plog
P
E
  • Question
Power BI, IF statement with OR in DAX
Replies
2
Views
191
elikab92
E
A
Query to Calculate percentages of specific records in a table
Replies
5
Views
693
mike60smart
mike60smart

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom