I am trying to calculate rebate based on a logic. It should be a simple formula but for some reason I am not able to get the formula working.
Need help to figure out where I am going wrong.
Attaching the data and the workflow
Solved! Go to Solution.
@vrajgopal
Your "Achieved target" and and "Stretch Target" need to be numeric fields in order to perform numeric calculation.
The problem is with your "Achieved target" and "Stretch Target". You are trying to build a formula to multiple two values but these two are strings 😉 If you use a select tool to convert them or better yet, set them as numbers in your excel file that'll fix them
Thank you. Looked at all possible solutions except checking the data type 🙂