How to Calculate

[Anonymous]

 

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?

[v-yulgu-msft]

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