4 Replies Latest reply on Jan 29, 2019 10:21 AM by Deepak Rai

    Help with creating calculation field

    P Yush

      I am trying to   create a Sort by Calculated Field

       

      IF data_type = “ABC” then product_A_Share

      Else if data_type  = “XYZ” then product_B_Share 

       

      Where product_A_share = product_A_Rx/market_A_Rx

                  product_B_Share =  product_B_Rx/market_B_Rx

       

       

      But somehow I am getting error saying “cannot mix Aggregate and Non-Aggregate comparisons"