I'm trying to get an average of sales (field is 'Trailing 13') for just those locations where the 'Owner' is equal to 'I'. I use the following simple formula, but there is an error in the formula somewhere:
Avg {<[Owner]= ('I') >}[Trailing 13]
Additional info: The 'Owner' and 'Trailing 13' fields are loaded from separate worksheets, and are connected by the field "PS#". (Not certain if this additional information is useful, but perhaps is part of the issue).
I greatly appreciate anyone who can help with probably is a very simple problem. 😀
