% calculation

[AgnesL]

Hi, I am not sure how to approach this. I need to calculate a % where if the cell is "Value", then use the "Tax" % instead of calculate its own. I know how to do it in excel (with IF & Xlookup) but I am struggling to do that in Alteryx. 

Thank you for your help

[binuacs]

@AgnesL One way of doing this

[AgnesL · Accepted solution]

Wow. I have been trying for over an hour. You made it looks so easy. Thank you. 😀