Rounddown

[Ultralightbeam]

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

Value1	Value2	Value3	Desired Result
4		5	4
3			3
3	4		3
5	5	5	5

Formula on Excel:

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

[grazitti_sapna · Accepted solution]

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.

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

If this helps kindly mark this post as solution.

Thanks.

[clmc9601]

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]

@clmc9601  tried that before it does still count null rows

[grazitti_sapna]

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 

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

Thanks.

[Ultralightbeam]

Hello @grazitti_sapna 

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 · Accepted solution]

@Ultralightbeam  yes floor will work in this case.

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

Thanks.