Forum Discussion

Ragnar_Raghu's avatar
Ragnar_Raghu
New Member
6 years ago

Sumif between two tables

Hi All,   I have two Tables   Table 1 has hourly price of electricity for each day   Date               hour-block   Price 01/04/2017     0 to 1            200 01/04/2017     1 to 2          ...
Need Help
baronraghu's avatar
baronraghu
Helper III
6 years ago

Hi Ashish,

 

Thanks for your prompt response. I appologize for the inconvinece , The sum in the summary table has beeen incorrect. I have updated the summary table as below

 

Price Range    Units traded

 below 100       100

101 to 200      824

201 to 300       0

301 to 400       400

401 to 500      500

above 501      2541 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.