CONDITIONAL FORMULA

[Rajesh_27]

Dear Members,

I am trying to apply conditional formula in alteryx and need your help in developing the formula. below is the data from excel sheet and the formula i need is for column Quarter and XYZ, i have also pasted the formula from excel. 

[kamal03 · Accepted solution]

Hi @Rajesh_27 

Please try the below workflow, Do not forget to remove extra rows at the bottom of the Excel, Please let me know if it worked or not.

[Rajesh_27]

hi Kamal,

Thanks for helping me, it worked.