Hi all,
new to this so this may seems a little elementary Im sure.
Trying to figure out how to perform the following
Table includes
YEAR, WEEK, ITEM, SALES
I need a field that gives me something if SALES are less that 50
I can get it to work with Expr1: IIf([SALES]<50,"UNDER 50",Null)
but it doesnt work if I have sums on the original table.
Sometimes I need to delete WEEK and have the total SALES for the whole year as gouped by and SUM.
The Expr1: IIf([SALES]<50,"UNDER 50",Null) doesnt work on the final calculated number.
thanks