how can we subtract one kpi value in a kpi list with another kpi value existing in another kpi list and show the difference in a seperate kpi ?
how can we subtract one kpi value in a kpi list with another kpi value existing in another kpi list and show the difference in a seperate kpi ?
I think I am following the question, but to confirm - does the scenario below align with what you are looking to achieve? If not, can you please provide more context? We have numerous KPIs we use in calculations as well as variables. Depending on the scenario, the answer may vary.
Simple Example:
Customer ordered 20 EA of xyz (total requested quantity)
shipped = 10 EA of xyz (shipped quantity)
Open/Unshipped = 10 EA of xyz (open quantity)
(total requested quantity) - (shipped quantity) = (open quantity)
ya you have got it right but the challenge I am getting is that there is a dropdown, that is filtering the KPIs at real time, so that change I want to store and further calculate based upon that
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.