4 Replies Latest reply on Oct 24, 2017 3:40 PM by Ryan Smith

    Multiplying Across Tables

    Ryan Smith



      Is it possible to multiple across tables? I have a calculated field that is making a percentage and I want to multiply that against the countd of complaints.


      Here you can see the percentage. I am only concerned with the No's (couldnt hide the yes) and I want to multiply it by the corresponding numbers by company.

      So for example I would like to get a weighed number by multiplying 1.029% against the 128 bank account issues. The formula in the first screen is in the bottom screen.

      I would post the workbook but it is too large. Thank you for all your help. This community has been very helpful.