Hi I need help for Dashboard KPI for cancellation metric,
Cancellation target is = 20%
Cancellation weight is =25%
if the cancellation actual increases the attainment for cancellation must be <25%
what is the excel formula for % to goal and % attainment
thanks