9 Replies Latest reply on Sep 19, 2017 4:45 PM by Justin Larson

    Cannot Mix Aggregate and Non-Aggregate functions in custom calculation....

    Kathryn Briggs

      I am trying to fix the below calculation so my value returned only includes dollar values for styles marked as "flex" (a category which I uploaded from an excel document) and had dollar sales in 2017.

      I understand these functions are aggregate and non-aggregate which is why my calculation is wrong.

      Can anyone please suggest how I may fix the calculation to get my desired result? Thanks!

       

      Tableau.PNG