Formula assistance needed

[vrajgopal]

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

[Qiu · Accepted solution]

@vrajgopal 
Your "Achieved target" and and "Stretch Target" need to be numeric fields in order to perform numeric calculation.

[joshuaburkhow · Accepted solution]

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

[vrajgopal]

Thank you. Looked at all possible solutions except checking the data type 🙂