Excel Calculation in Alteryx

[BRRLL99]

Hi

I'm looking for following Calculation in Alteryx

I need Cost to benefit Ratio

Sample Data has been added with expected output

[PhilipMannering · Accepted solution]

👋 @BRRLL99 

I think this does what you need,

[flying008 · Accepted solution]

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.