Hello. I have a table that lists daily sales counts. I've created a summary report that aggregates this information by month but now I'm trying to add in a Revenue field where it takes in the total count for the month and multiplies this by a percentage that is driven by a tier. So if the total monthly count <=x, count*0.015.

The problem I believe I'm having is that although my summary table aggregates the daily totals to monthly, the formula is still looking at the daily counts so is not registering monthly counts that reach the next level(s) of tiers in order to run the calculation correctly. So everything is calculating based on the first tier as the daily counts do not meet or exceed the first tier.

How can I fix this so that my formula looks at the aggregate monthly totals as opposed to the daily totals?

Thanks!

The problem I believe I'm having is that although my summary table aggregates the daily totals to monthly, the formula is still looking at the daily counts so is not registering monthly counts that reach the next level(s) of tiers in order to run the calculation correctly. So everything is calculating based on the first tier as the daily counts do not meet or exceed the first tier.

How can I fix this so that my formula looks at the aggregate monthly totals as opposed to the daily totals?

Thanks!