convert excel formula to alteryx

[Raghadhq]

Hello

I have attached excel file for the formula i use in excel, and i want to convert it to Alteryx is that possible.

thanks  

[rzdodson · Accepted solution]

@Raghadhq that is definitely possible. What I would recommend doing is going Input -> Cross Tab -> Formula. The Cross Tab tool is to just get your like data on one row like so:

From there, here are the Alteryx equivalents to match your data set from here:

ROUNDUP (Excel) = CEIL (in Alteryx)

ROUND (Excel) = ROUND (in Alteryx)

LEFT = LEFT in both

[Raghadhq]

thanks!