Count frequency of values calulcated

[billuran]

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!

[billuran]

Sunny as always you the man!! Works perfectly!