Getting Error msg on report. When win rate and Account value is null

IF(OR(NOT(ISNULL(Win_Rate_Value__c)),NOT(ISNULL(Amount))),(Win_Rate_Value__c / Amount) , 00)

User-added image

March 17, 2017
·
Answer
·
Like
0
·
Follow
1

Steve Loudermilk
if(AND(NOT(ISNULL(Amount),Amount<>0),(Win_Rate_Value__c / Amount),00)

I believe something like this would do it. This way you never get a 0 or a null in the divisor

March 17, 2017
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Getting Error msg on report. When win rate and Account value is null

You need to sign in to do that.