9 Replies Latest reply on Apr 4, 2018 9:00 AM by Colleen Reynolds

    Formula question

    Colleen Reynolds

      Hi, I am trying to calculate a ratio using 2 different lines from a table.   In the example attached, I am trying to create a percentage which takes the Feb column - count of loan number 26 divided by Grand Total of 90+Delq amount of  849.   March would be 41/820 etc. I am not sure the best way to write a formula to use to pull out just these 2 amounts for each column to arrive at the monthly percentages. I would appreciate any suggestions. Thank you.

       

      Message was edited by: Colleen Reynolds reattached after extracting data source