We custom module called Cell Leases, we have a Formula field called Est Site Gross. I am attempting to update the formula to reflect the different rent values offered by various service providers multiplied by the Rent Index of the site, resulting in a Currency value. Here's a brief sample of the formula I wrote, cutting out most of the values for the service providers.
${CELL LEASES.Rent Index}
*If(${CELL LEASES.Service Provider}=Rogers,'5000','0')+If(${CELL LEASES.Service Provider}=Bell Mobility,'4000','0')