Below is a crosstab from 2 blended data sources, the linking key is Vehicle Name. Comp1 comes from the secondary data source and Record Check from the primary source.
I'm trying to create a calculated field in the primary data source hat returns "Yes", "No" or "NA" based on the various combinations of Comp1 and Record check. I tried something like
if ATTR([Sheet1].[Comp1])='Yes' and [Record Check]=true then "Yes" elseif
if ATTR([Sheet1].[Comp1])='Yes' and [Record Check]=false then "No" else "NA" end
but I'm getting a "cannot mix agg/non-agg error" on the and operator. Can't seem to find anyway around this. Any ideas?
Thanks for any help in advance!
1 answer
