Scoring Calculation

[Syndicate_Admin]

Hello, I have a sales information of more than 1000 products, each product has a score every quarter, for example:

Product sales A exceeds 8 sales must stay at 8, product b exceeds 9 sales must stay 9, if product C exceeds 10 sales must stay at 10.

These sales can be the sum of one month, two months or three months (quarter) sold.

For example:

If Product A the total units sold is greater than 8 your score is 8 otherwise your units sold

This depending on the selection of the month, you can select up to 3 months together that would be the quarter.

PS: How do I upload a file?

[v-henryk-mstf]

Hi @Syndicate_Admin ,

It doesn't seem clear what your requirement is, what exactly does it mean when the product reaches a certain value and the status is displayed as a certain value. Is it possible to provide more information such as a screenshot of the desired result?

Looking forward to your reply.

Best Regards,
Henry

[Syndicate_Admin]

Of course, I explain, the filters are by Year AND Month, you can select a month as several.

In the tables on the left are the values for each month with its respective goal, those on the right are accumulated, from two months to more, which must consider the goal for each month.