I have a calculated field in a worksheet that I want to insert into a calculation in a different worksheet. I get the "Cannot mix aggregate and non-aggregate arguments" error, even though I have created a Join Key – populated by an “X” – in the data on both worksheets. I have tried using attr() on the non-aggregate arguments but that doesn't work.
Thank you for helping.
Update: I realized that this calculation affected other calculations in the viz. So I went through all of them and added attr() on every non-aggregate argument. Seems to work OK now.