Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to Calculate

 

 

 

These are the three tables which i have in my dataset. Consumption, the site, the genetator code which supplies to that site. What would the formula be so that i could calculate price times consumption?

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous,

     

    Please show us your desired output. In above sample tables, there existing multiple consumption values for a single SITE item, then, how to determine which one should be referred to when calculating "price times consumption" for each site?

     

    Regards,

    Yuliana Gu