Skip to main content
Trying to build a report formula field for on an Opportunity report and I am struggling. I built a Hit Ratio formula: 'WON:SUM / RowCount' which is great. Not I am trying to apply the same hit ratio logic but this time for $$ rather that record count. Cannot figure out how to say divide 'WON: Amount:SUM / ALL: Amount:SUM'. I feel like it should be easy, but it is eluding me. @Steve Molis any idea how? Tried an IF function but not clear how I would say IF Won then return Amount. Thanks!
10 commenti