1 Reply Latest reply on Nov 29, 2017 1:28 PM by Deepak Rai

    Calculation for Aggregate/Non-Aggregate Comparisons

    Teresa Wright

      Sorry I can't share work data due to security reasons.


      I have a "Cost Per Voucher' calculation that produces the correct results.

      screen shot 1.jpg


      I need to create a calculated field for Cost Per Voucher for calendar year 2016 (string field).  However I'm getting the "Cannot mix aggregate/non-aggregate" error.  Is there a way to write this calculation so Tableau will accept it?



      screen shot 2.jpg