1 Reply Latest reply on Jul 10, 2018 8:51 AM by kunal.dongre.0

    calculating by a constant value

    Matan Bracha

      Hi guys, I have a question about fixed-calculation.

       

      I have a column which called "group size", and each record saves that number.

      I also have a column called "Total members" which is the same in all the records (for the same date).

      I need to calculate "% of total" (but NOT by Quick Table Calculation - the total is bigger then the groups sum, there are a few groups I left out on purpose).

      Which means: (group size)/(total members) ---> The problem appears when trying to calculate this on several groups SUM(group size)/(total members), How can I take just a single value to work by it?

       

      Thanks a lot!!!