SOLVED
excel formula to Alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Raghadhq
7 - Meteor
‎12-14-2023
04:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I have attached excel file for the formula i use in excel, and i want to convert into Alteryx, would that be possible?
thanks
Solved! Go to Solution.
Labels:
- Labels:
- Designer Cloud
2 REPLIES 2
17 - Castor
‎12-14-2023
06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Raghadhq
Here's how:
- Convert date time field to proper alteryx format
- Compute difference using multi-row formula tool.
- Note: I used datetimediff() in seconds, and converted to hours. Using the hours setting rounds off which is not optimal for the calc.
- Implement your logic using if statements.
‎12-16-2023
09:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks it worked!
![](/skins/images/7C0E562E11459B4559A865ABC88017AF/responsive_peak/images/icon_anonymous_message.png)