Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Rounddown

Ultralightbeam
8 - Asteroid

I can't figure out on how to do this on alteryx

Value1Value2Value3Desired Result
4 54
3  3
34 3
5555

 

Formula on Excel:

 

=ROUNDDOWN(AVERAGE(A1:A3),0)

 

 

 

6 REPLIES 6
grazitti_sapna
17 - Castor

Hi @Ultralightbeam , the formula you mentioned needs a correction. The calculation mentioned should be 

 

 

 

 

 

=ROUNDDOWN(AVERAGE(A1:C1),0)

 

 

 

 

 

 calculating the average along the row.

 

I have prepared a workflow  if it helps. First you need to take the average using summarize tool then you can round down the value using formula tool.

 

EDIT: FLOOR(Desired Result) will help to round down the value.

 

grazitti_sapna_0-1613544538029.png

 

 

Note: This solution is dynamic will run for n number of columns.

 

If this helps kindly mark this post as solution.

Thanks.

 

Sapna Gupta
clmc9601
13 - Pulsar
13 - Pulsar

Hi @Ultralightbeam,

 

How about this expression within the formula tool? It's not particularly dynamic, but it is simple.

 

Floor(Average([Value1],[Value2],[Value3])) 

 

Ultralightbeam
8 - Asteroid

@clmc9601  tried that before it does still count null rows

grazitti_sapna
17 - Castor

Hi @clmc9601 , in your case the formula would consider the null values as well that is 
Sum(value1,value2,value3)/3. The output would be 

grazitti_sapna_0-1613543380115.png

 

But in this case we need not to consider the null values as per the desired result.

 

Thanks.

Sapna Gupta
Ultralightbeam
8 - Asteroid

Hello @grazitti_sapna 

Ultralightbeam_1-1613543769510.png

 

 

if you will look into row 5 - result is 5 while it should be 4 rounddown

 

Edit:
I think i got it by using Floor([Desired Result])

Please correct me if i am wrong.

grazitti_sapna
17 - Castor

@Ultralightbeam  yes floor will work in this case.

grazitti_sapna_0-1613544436660.png

 

Sorry for the inconvenience. Floor is the better option in this case.

 

Thanks.

 

Sapna Gupta
Labels
Top Solution Authors