Forum Discussion

i820017's avatar
i820017
Icon for Resolver II rankResolver II
4 years ago
Solved

Dividing Columns in Multiple Tables

I am trying to create a new column entitled 'Analyst Daily Average'. To get this column, you have to use the calculation: (Number of P&Ps Completed) / (Days Worked).    (Number of P&Ps Completed) ...
Need Help
  • i820017's avatar
    i820017
    4 years ago

    I figured it out using MAX...thanks though!!

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi i820017 

 

Are the two tables related through an Analyst ID or something of the like?  If so, you should be able to achieve this.

 

Please feel free to provide dummy data if you'd like further assistance.


Thanks heaps!

Theo

 

i820017's avatar
i820017
Icon for Resolver II rankResolver II
4 years ago

I figured it out using MAX...thanks though!!