1 Reply Latest reply on Jan 18, 2012 3:16 PM by Jeff Roberts

    Data blending problem

    Jeff Roberts

      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.

       

      Jeff