6 Replies Latest reply on Apr 24, 2018 2:38 PM by Kanupriya Dhiman

# Gain/Loss Ratio

Hi Experts

I am trying to recreate a viz from this inspiration here (image attached_. And basically I have created the left hand side of it displaying the losses and wins in the form of diverging charts, but getting kind of stuck with calculating the win/loss ratio. It seems my formula is not working. The formula should be in the form of => +1 when wins are more than losses and =< -1 when losses are more than wins. I have attached buy workbook here and any guidance on this matter would be appreciated.

• ###### 1. Re: Gain/Loss Ratio

HI Kanupriya

Regards,

Shin

• ###### 2. Re: Gain/Loss Ratio

Sorry about that, here it is.

• ###### 3. Re: Gain/Loss Ratio

HI Kanupriya

Not sure about the logic of win-lose ratio, but speculating something.

Thanks,

Shin

• ###### 4. Re: Gain/Loss Ratio

This is so cool Shinichiro. Thanks a ton! The logic behind calculating this ratio is to between hires and departures and knowing the overall picture whether we are winning or loosing against each company.

Quick question, why are we using Max & Min calculated formulas here?

Regards

Kanu

• ###### 5. Re: Gain/Loss Ratio

To align the width of left and right side from origin(0)

Thanks,

Shin

• ###### 6. Re: Gain/Loss Ratio

Ya I figured out. Thanks so much!