Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

convert excel formula to alteryx

Raghadhq
7 - Meteor

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  

2 REPLIES 2
rzdodson
12 - Quasar

@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:

 

Solution.png

 

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
7 - Meteor

thanks!

Labels
Top Solution Authors