SOLVED
Excel Calculation in 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
BRRLL99
11 - Bolide
‎09-30-2022
01:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I'm looking for following Calculation in Alteryx
I need Cost to benefit Ratio
Sample Data has been added with expected output
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
2 REPLIES 2
PhilipMannering
16 - Nebula
‎09-30-2022
01:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
flying008
15 - Aurora
‎09-30-2022
01:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @BRRLL99
Maybe you want this result.
The Formula:
Tostring(Max( [Total_Costs]/[Total_Benefits], 1)) + " To " + Tostring(Max( [Total_Benefits]/[Total_Costs], 1))
******
Please mark it is a solution with if help you get want result.