Hi folks, I need your help in figure out what I am doing wrong on with the expression below. In short, I need to do the average and rounding that average to 2 decimal places fish that are greater than 2 in length. It is imperative that it is done as "expression" since the same query has other calculation that counts the same records differently.
Non working expression: IIf([FishLenght]>2,Round(Avg([FishLenght]),2))
Working expression without filtering specific fish length: Round(Avg([FishLenght]),2)