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"