Hello All,
I am in the process of figuring out a way to show the number of occurrences for a specific month showing a zero value.
For example for the month of July, i am trying to get the settlement count seen in yellow from the data set.
What would my count be if formula look to ensure it is scanning the month and the value of 0 or $-.
What i am trying to produce:
Data Set
I am in the process of figuring out a way to show the number of occurrences for a specific month showing a zero value.
For example for the month of July, i am trying to get the settlement count seen in yellow from the data set.
What would my count be if formula look to ensure it is scanning the month and the value of 0 or $-.
What i am trying to produce:
| Row Labels | Count of Settlement Amount | Settlement Count = 0 |
| Jul | 2,976.00 | 168 |
Data Set
| Calculation Interval (Beginning CPT) | Date | Time | Interval Quantity (MWh) | Fixed Price ($/MWh) | ERCOT West Hub Interval Real-Time Locational Marginal Price ($/MWh) | Fixed Price Payment (Generated Quantity * Fixed Price) | Floating Price Payment (Generated Quantity * Floating Price) | Settlement Amount |
7/5/2022 10:45 PM | 7/5/2022 | 10:45:00 PM | 2.290 | $33.50 | $57.26 | $76.70 | $(131.10) | $(54.40) |
7/5/2022 11:00 PM | 7/5/2022 | 11:00:00 PM | 0.000 | $33.50 | $55.68 | $- | $- | $- |
7/5/2022 11:15 PM | 7/5/2022 | 11:15:00 PM | 0.317 | $33.50 | $56.36 | $10.61 | $(17.85) | $(7.24) |
7/5/2022 11:30 PM | 7/5/2022 | 11:30:00 PM | 1.685 | $33.50 | $54.62 | $56.44 | $(92.02) | $(35.58) |
7/5/2022 11:45 PM | 7/5/2022 | 11:45:00 PM | 3.758 | $33.50 | $53.85 | $125.91 | $(202.39) | $(76.48) |
7/6/2022 12:00 AM | 7/6/2022 | 12:00:00 AM | 4.565 | $33.50 | $54.52 | $152.92 | $(248.87) | $(95.95) |
