Max value

Hello

I am trying to return the max revenue among the following clients. Could you help me write a formula for this?

 

Thanks!

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Eric Fomba - you can achieve in two ways

    1. Create a group_max formula as   Max value: group_max (revenue ) 

    Then use the following clause in search bar:  max value client in (client max value) if you are in 5.3.2 version and above

    2. If you are below that version

    create another flag to compare revenue with max revenue as 

    Max. flag: if (revenue = max value ) then 1 else 0 

    then use the following clause in search bar: client revenue max. flag = 1

     

    Screenshot is attached for both.

    Like
  • Awesome! Thanks!

    Like
Like Follow
  • Status Answered
  • 3 wk agoLast active
  • 2Replies
  • 8Views
  • 2 Following