Forum Discussion

harib's avatar
harib
Post Patron
7 years ago
Solved

Ratio

I have a data like below. i want a ratio for stage wise lead generation.

below formulas i have used 

Opportunity Name Distinct = DISTINCTCOUNT('ReBU Opportunities History Report'[Opportunity Name])
To Stage count = COUNTA('ReBU Opportunities History Report'[To Stage])
 
ex : tostage/ 18 is a count Opportunity Name Distinct.

but ration is wrong . Appriciate if anyone can help.

 

 

Need Help
  • harib's avatar
    harib
    7 years ago
     
    Below formula is working 
     
    Ratio = DIVIDE([To Stage count],'ReBU Opportunities History Report'[Opportunity Name Distinct])-1
     
    Thanks
     

10 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    harib

     

    What is exactly wrong. The numerator or denominator?

    Any example of how the correct values should have been displayed?

    • harib's avatar
      harib
      Post Patron
      7 years ago

      themistoklis

      Ratio should be come like below . But i have used static values of 18. That's not the correct way. i want it dynamically insead of giving static values of 18.

       

      formula : Ratio = [To Stage count]/18

       
      hope u understand