Hi,

I've asked your assistance regarding this before. However, my issue before was too many characters in the formula. I was able to fix that, but now I'm getting a syntax error. I was hoping you could take a look and write it in an acceptable format. 

If(Contains(${Potentials.Contract Term},'1 year'),(${Potentials.Full 1st Year Revenue}*1),If(Contains(${Potentials.Contract Term},'2 years'),(${Potentials.Full 1st Year Revenue}*2),If(Contains(${Potentials.Contract Term},'3 years'),(${Potentials.Full 1st Year Revenue}*3),If(Contains(${Potentials.Contract Term},'4 years'),(${Potentials.Full 1st Year Revenue}*4),If(Contains(${Potentials.Contract Term},'5 years'),(${Potentials.Full 1st Year Revenue}*5),If(Or(Contains(${Potentials.Contract Term},'6'),Contains(${Potentials.Contract Term},'7'),Contains(${Potentials.Contract Term},'8'),Contains(${Potentials.Contract Term},'9'),Contains(${Potentials.Contract Term},'10'),Contains(${Potentials.Contract Term},'1'),Contains(${Potentials.Contract Term},'2'),Contains(${Potentials.Contract Term},'3'),Contains(${Potentials.Contract Term},'4'),Contains(${Potentials.Contract Term},'5'),Contains(${Potentials.Contract Term},'11')),${Potentials.Full 1st Year Revenue},0))))))*(${Potentials.FC (%)}/100)

Thanks,

Linda