Rounddown
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Ultralightbeam,
How about this expression within the formula tool? It's not particularly dynamic, but it is simple.
Floor(Average([Value1],[Value2],[Value3]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@clmc9601 tried that before it does still count null rows
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Ultralightbeam yes floor will work in this case.
Sorry for the inconvenience. Floor is the better option in this case.
Thanks.