Forum Discussion

mohammedald's avatar
mohammedald
Icon for Helper I rankHelper I
3 years ago
Solved

Need your help in ratio calculation

Hello how are you guys I hope you are doing well, this might seem similar to another post I made and yes you are right the thing is I missed something important and need your help again, I have a rat...
Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago

    A ')' was omitted at the end of the First CALCULATE(). I have included it below:

    Winning Quantity Ratio = DIVIDE(CALCULATE(COUNT('Main Data'[Deal Stage]),'Main Data'[Deal Stage]="Won"), CALCULATE(COUNT('Main Data'[Deal Stage]),('Main Data'[Deal Stage]="Won"|| 'Main Data'[Deal Stage]="Lost")))) 

    Winning Dollar Ratio = DIVIDE(CALCULATE(SUM('Main Data'[Final PO. Value]),'Main Data'[Deal Stage]="Won"), CALCULATE(SUM('Main Data'[Final PO. Value])+SUM('Main Data'[Customer Expected Budget]),('Main Data'[Deal Stage]="Won"|| 'Main Data'[Deal Stage]="Lost"))))

Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago

Please paste the formula that shows the error message

mohammedald's avatar
mohammedald
Icon for Helper I rankHelper I
3 years ago

the names are changed because I used them in another data set 

 

Winning Quantity Ratio = DIVIDE(CALCULATE(COUNT('Main Data'[Deal Stage]),'Main Data'[Deal Stage]="Won", CALCULATE(COUNT('Main Data'[Deal Stage]),('Main Data'[Deal Stage]="Won"|| 'Main Data'[Deal Stage]="Lost")))) 

 

Winning Dollar Ratio = DIVIDE(CALCULATE(SUM('Main Data'[Final PO. Value]),'Main Data'[Deal Stage]="Won", CALCULATE(SUM('Main Data'[Final PO. Value])+SUM('Main Data'[Customer Expected Budget]),('Main Data'[Deal Stage]="Won"|| 'Main Data'[Deal Stage]="Lost"))))

  • Padycosmos's avatar
    Padycosmos
    Icon for Solution Sage rankSolution Sage
    3 years ago

    A ')' was omitted at the end of the First CALCULATE(). I have included it below:

    Winning Quantity Ratio = DIVIDE(CALCULATE(COUNT('Main Data'[Deal Stage]),'Main Data'[Deal Stage]="Won"), CALCULATE(COUNT('Main Data'[Deal Stage]),('Main Data'[Deal Stage]="Won"|| 'Main Data'[Deal Stage]="Lost")))) 

    Winning Dollar Ratio = DIVIDE(CALCULATE(SUM('Main Data'[Final PO. Value]),'Main Data'[Deal Stage]="Won"), CALCULATE(SUM('Main Data'[Final PO. Value])+SUM('Main Data'[Customer Expected Budget]),('Main Data'[Deal Stage]="Won"|| 'Main Data'[Deal Stage]="Lost"))))

    • mohammedald's avatar
      mohammedald
      Icon for Helper I rankHelper I
      3 years ago

      Thank you, Pady again 

  • mohammedald's avatar
    mohammedald
    Icon for Helper I rankHelper I
    3 years ago

    I just wanted to remove the =>2023 clause