Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dividing values from 2 different tables

I have this data from 2 different table(no relation), I want to divide Material stop counter/runtime for each different size.
for example for line 1 : 10/26665 and store the result in a column
NB: for each change of month or line of course the values will change for both tables

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    I believe you can use relatedtable function and divide the values using that.

     

    Let me know if it helps.

     

    Thanks!

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank for your reply, but it doesn't help because the tables are not related

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.