Hi,
I have a table with date, model, category, to send, KPI Ref, and Stock.
I need to perform a calculation with these conditions:
- Numerator: KPI Ref=X, to send>0 and stock=0
- Denominator: KPI Ref=X, to send>0
All these fields only depends on the model, date and Category ignoring the colour.
If a model for a date and category has a color with a stock other than 0, it will not count in the numerator.
A model for a date and category must have an 'X' in the KPI Ref field in at least one of the colors so that they meet the condition in both the numerator and the denominator.
A model for a date and category must have a value greater than 0 in the field to send in at least one of the colors so that they meet the condition in both the numerator and the denominator
The last four columns of the excel are the expected output for the numerator, denominator and the calculation for each model and the total calculation.
I attach the excel and the app with the table and the KPI with tests that I have done.
Regards.
