You need to sign in to do that
Don't have an account?
Felix Quinones
IF There is a value, then due a division. If not, then null.
Hello All,
I'm trying to create a formula for a compliance field (variable). The field could have values or not. If the field has values (Not Blank), I need that the field make a division (Q1_Value__c / Q1_Goal__c). If there is no values, I need the fielf diplay "N/A" or stay blanck.
Something like the following:
IF (OR
(NOT(ISBLANK(Q1_Goal__c)),
Q1_Value__c / Q1_Goal__c),
ISBLANK(Q1_Goal__c), "N/A"))
Thanks in advance.
Hi Flexi,
Sorry I missed that closing bracket in expression. Try this below :-
If this time solve your issue, please mark it as best answer.
If not let us know again, we will try our best to fix it.
Regards,
Priya Ranjan
All Answers
IF( AND( NOT(ISBLANK( Q1_Goal__c )) ,NOT(ISBLANK( Q1_Value__c ))) , Q1_Value__c/ Q1_Goal__c, null)
Thanks!
Hi Felix,
Please mark it as the Best Answer so that it can help others in the future.
Regards,
Priya Ranjan
Abhinav, your code work but I'm looking for something that returns "N/A".
Priya, your code look great, but there is a error in the syntaxis. The formula indicate that there is a parenthesis missing.
Thanks both for your help.
Felix.
Hi Flexi,
Sorry I missed that closing bracket in expression. Try this below :-
If this time solve your issue, please mark it as best answer.
If not let us know again, we will try our best to fix it.
Regards,
Priya Ranjan