1 Reply Latest reply on Jun 27, 2016 12:18 PM by Derrick Austin

    Having trouble figuring out max value using calculated field

    Samuel Tecca

      ([Revenue]/10694883.99)*1

       

      I need to display the calculation above as ([Revenue ($)]/MAX([Revenue ($)]))*1 but an error keeps coming up  that says "cannot mix aggregate and non-aggregate arguments" Calculation Error.  If there is another way to figure this calculation out to make it valid please help!