Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Re: Remove minimum from a group of numbers

how about
Sum([field 1], [field 2],...[field 10])
-
Min(([field 1], [field 2],...[field 10])

but what if there is only one or two values??


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

1 Reply

Sort By
  • MikeKlausing's avatar
    MikeKlausing
    Qrew Assistant Captain
    5 years ago

    That formula should work except in the case where fields 8, 9, and 10 etc are blank or zero. I need to have something that subtracts the Min of those values 1-10 that are also greater than 0

     

    Thank you,
    Mike Klausing

     



    ------Original Message------

    how about
    Sum([field 1], [field 2],...[field 10])
    -
    Min(([field 1], [field 2],...[field 10])

    but what if there is only one or two values??


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------