Hello, I have a data set basic description:
Date,ID,Value
and a Mapping Table:
ID, Weight
I want to then create a table that has field called CALCCOUNT with integers 0-100
I want to then count the number of dates where sum of the round((Value*Weight),0) for that date equals CALCOUNT
Example Chart I would like:
| CALCOUNT | Frequency of Dates |
|---|
| 0 | 1 |
| 1 | 25 |
| 2 | 4 |
| ... | 45 |
| 99 | 55 |
| 100 | 23 |
Thank you for your help!
