• Mark McGrane
• NEWBIE
• 20 Points
• Member since 2017

• Chatter
Feed
• 0
• 0
• 0
Likes Given
• 2
Questions
• 3
Replies
Hi There,

I am having a few issues with populating a Formula Field as I need to run nested IFs on it.

Basically what I am looking to do is to determine a rating based on the Business Type and if the last bill has consumption.

So if the Business has previous consumption

The Rating for Gyms is A-, Rating For Hotels is B-, Rating For Offices is C-

If there is no consumption

Then The Rating for Gyms is A+, Rating For Hotels is B+, Rating For Offices is C+

Im pretty sure its something small but I keep getting "Error: Syntax error. Missing ')'

IF((ISPICKVAL(Does_The_Customer_Have_Consumption__c, "Yes")

Hi There,

I am having a few issues with populating a Formula Field as I need to run nested IFs on it.

Basically what I am looking to do is to determine a rating based on the Business Type and last bill amount

So if the Business has previous consumption

The Rating for Gyms is A-, Rating For Hotels is B-, Rating For Offices is C-

If there is no consumption

Then The Rating for Gyms is A+, Rating For Hotels is B+, Rating For Offices is C+

Im pretty sure its something small but I keep getting "Error: Syntax error. Missing ')'
Hi There,

I am having a few issues with populating a Formula Field as I need to run nested IFs on it.

Basically what I am looking to do is to determine a rating based on the Business Type and if the last bill has consumption.

So if the Business has previous consumption

The Rating for Gyms is A-, Rating For Hotels is B-, Rating For Offices is C-

If there is no consumption

Then The Rating for Gyms is A+, Rating For Hotels is B+, Rating For Offices is C+

Im pretty sure its something small but I keep getting "Error: Syntax error. Missing ')'

IF((ISPICKVAL(Does_The_Customer_Have_Consumption__c, "Yes")

Hi There,

I am having a few issues with populating a Formula Field as I need to run nested IFs on it.

Basically what I am looking to do is to determine a rating based on the Business Type and last bill amount

So if the Business has previous consumption

The Rating for Gyms is A-, Rating For Hotels is B-, Rating For Offices is C-

If there is no consumption

Then The Rating for Gyms is A+, Rating For Hotels is B+, Rating For Offices is C+

Im pretty sure its something small but I keep getting "Error: Syntax error. Missing ')'