Hot answers tagged

2 votes

Multiple If statement with Picklist values

You'd place the next if statement where the last null is right now. However, since we're here, we may as well optimize the rest of the formula, too. We can make it far more legible by doing this: IF( ...
sfdcfox's user avatar
  • 481k
2 votes

Need help on converting an excel financial formula to apex code

The portion of the expression (ResidualValue/((1+(3%/12))^Term)) you have coded as (residualValue / Math.pow((d1), d2) but d2 = term -i and the excel formula wants simply term so you need (...
cropredy's user avatar
  • 69.9k
2 votes

Formula to populate a field if closed date is blank

You can use the ISBLANK function to check if the case has a closed date or not. The ISBLANK function returns TRUE if the expression is blank, and FALSE otherwise. You can use this function to create a ...
Tushar Jadav's user avatar
1 vote

Tilde Error in Formula

Surround the tilde in either single or double quotes. "Smart" quotes (i.e. “ ” or ‘ ’) will not work Strings and single characters need to be enclosed in quotes. Otherwise the formula tries ...
Derek F's user avatar
  • 59.3k

Only top scored, non community-wiki answers of a minimum length are eligible